Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

selection logic

Former Member
0 Kudos

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.

4 REPLIES 4

Former Member
0 Kudos

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

0 Kudos

hi santosh,

thanks for clearing the doubts

rohan

0 Kudos

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
0 Kudos

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