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