Skip to Content
0
Former Member
Dec 01, 2008 at 09:34 PM

please correct me.

33 Views

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 aaddrnumber = tadrnr

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