Select data from Table1 based on Table2

[Former Member]

Hi Guys,

Can you guide me up on how to select data from Table1 based on Table2?

I want to fetch data which is not there in table2 in my table1 select query.

Is that I have to do it with the loops after I select data from both tables or can it be handled directly in my select query?

Please suggest.

Regards,

Kumar.

[Former Member]

Hi,

Select from Table1 into itab1

Select from Table2 into itab2 FOR ALL ENTRIES IN itab1

where <conditions>.

[Former Member]

hi

Try This

In Where condition filedname (Not Equal) < > itab2-fieldname.

select * from itab1

into table lt_tab.

seect * from itab2

into table lt_tab

for all entries in lt_tab

where name < >(Not Equal to)itab2-fieldname.

[Former Member]

Hi,

Use LEFT OUTER JOIN to meet your requirement.

Thanks,

Sudheer

[Former Member]

Thanks for your replies, I would try your suggestions....

[Former Member]

Problem solved.