please correct me.

[Former Member]

Can anybody tell me how the below stmt gets executed ?

I am not expert in inner joins ( i just have idea ). i really want to have a good understanding on this inner joins.

SELECT SINGLE a~name2 INTO lv_name2

FROM tvst AS t INNER JOIN adrc AS a

ON a_{addrnumber = t}adrnr

WHERE vstel = lv_vstel.

for lv_vstel, the above SELECT finds adrnr value from tvst table.

Based on above adrnr value, the program selects adrc tableu2019s name2 field .

Please correct me ?

Use meaningful subject in future.

Edited by: Vijay Babu Dudla on Dec 1, 2008 11:46 PM

[Former Member]

Hi

Your understanding is correct.

The two tables TVST and ADRC can be related to each other through Address number.

So, using the VSTEL (Shipping point), you get ADRNR (address number) from TVST. Go to the table ADRC with this address number find the matching record (TVST-ADRNR = ADRC-ADDRNUMBER) and get the address data.

Regards

Raj