please correct me.

Former Member — Mon, 01 Dec 2008 21:34:21 GMT

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

Re: please correct me.

Former Member — Mon, 01 Dec 2008 22:01:46 GMT

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

topic Re: please correct me. in Application Development and Automation Discussions

please correct me.

Re: please correct me.