Help Reqd to populate Internal Table from two DB tables

[Former Member]

Hi,

I want to do following:

DB Table 1 -> FieldA and FieldB

DB Table 2 -> FiledB and FieldC

Internal Table -> FieldA, FieldB and FieldC

Now for particular value ranges of FieldA I want to populate all fields of Internal Table.

Join between Table1 and Table2 should be left join (all fields of table1 and matched fields of table2)

I am not sure of the ABAP Statement, friends please help,

Thanks,

CD

[Former Member]

Hi

Here is your select stement.

select t1_{fieldA t1}fieldB t2~fieldC

into table itab

from table1 as t1 inner join table2 as t2 on

t1_{fieldB = t2}fieldB

where fieldA in r_fieldA.

Regards

Raj

[Former Member]

thanks