topic Select data from Table1 based on Table2 in Application Development and Automation Discussions

Select data from Table1 based on Table2

Former Member — Thu, 04 Feb 2010 10:01:45 GMT

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 — Thu, 04 Feb 2010 10:05:32 GMT

Hi,

Select from Table1 into itab1

Select from Table2 into itab2 FOR ALL ENTRIES IN itab1

where <conditions>.

Former Member — Thu, 04 Feb 2010 10:06:24 GMT

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 — Thu, 04 Feb 2010 10:10:04 GMT

Hi,

Use LEFT OUTER JOIN to meet your requirement.

Thanks,

Sudheer

Former Member — Thu, 04 Feb 2010 10:12:34 GMT

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

Former Member — Thu, 04 Feb 2010 12:11:05 GMT

Problem solved.