06-05-2008 1:46 PM
hi,
while selecting data from different tables using inner join and populating the internal table using into corresponding key word,is it neccesary to follow the order of the field for select stmt as declared in the internal table or program will take care of that automatically?
plz reply.
Rohan.
06-05-2008 1:48 PM
hi,
Into corresponding statement will take care of the order ... but when using into table then select has to be based on the order ...
Regards,
Santosh
06-05-2008 1:49 PM
06-05-2008 1:51 PM
hi,
But as said it is not better to use into corresponding statement speaking from performance point of view .. retrieve the fields based on order and use into table instead ..
Regards,
Santosh
06-05-2008 1:49 PM
Hi Rohan,
It is better to follow the order of the database table when we are writting select statement.
WHEN WE USE INTO CORRESPONING FIELDS IT TAKES CARE.
In where condition also i will be better to follow the order
Best regards,
raam