selection logic

[Former Member]

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.

[Former Member]

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

[Former Member]

hi santosh,

thanks for clearing the doubts

rohan

[Former Member]

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

[Former Member]

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