Skip to Content
0
Former Member
Jul 21, 2005 at 05:47 AM

Problem in making SQL Query

788 Views

Hello All,

I have one problem regarding sql query.

I have one internal table which contains equnr and bis as fields. There are two database tables egerr and eastl. The structure for tables are as follows:

Fields for egerr:

equnr, bis, logiknr in which first two fields form key.

Field for eastl:

anlage, bis, logiknr in which all fields form primary key.

I want to select records from internal table which does not have record in eastl.

For the reference we can extract logiknr from egerr by using intarnal table and then use this logiknr to check entry in table eastl. but i want those equnr which are in internal table but not mapped in eastl.

I want the most efficient solution for this as there are many records.

Thanks..... and if you have any queries then let me know.

Jignesh.