Hi all,
I am going to use the SELECT statement with INNER JOIN. When I use the table names(at 2 places), it is working properly. When I use the dynamic names, it is giving syntax errors.
Can you please explain me how to use the dynamic names for SELECT statement with INNER JOINs..
Ex:
SELECT afieldname1 bfieldname2
INTO CORRESPONDING FIELDS OF TABLE lt_table
FROM (lv_tabname) AS a INNER JOIN
(lv_ttabname) AS b ON ( afieldname1 = bfieldname1 AND
b~fieldname2 = sy-langu ).
(This is not working.......)
Thanks and Regards,
Balakrishna.N