Skip to Content
0
Former Member
Dec 07, 2006 at 08:49 AM

Query

56 Views

Hi all

I have 2 tables AD01DLI and ADO1DLIEF, i want to retrieve data, where dlinr value doest not match each of the two tables, and dopen field of table AD01DLIEF is not blank(' '), and there is an internal able T_COVP which has field blenr that should match with AD01DLI blenr.

As the data is too large in both of the tables .i need to do using single select statement, performace issue,

can any of u can guide me

rgds

anu