Need help for Customize the except query

[ptr_Electron]

I need one column from the table1 which need not be used comparassion but I need the colume (ID colum in this case)to get lised in the query result. Ex :

select ID a,b,c from table1 except select a,b,c from

table2

in the above example ID color of Table1 need not be compared with table to but just required in the query result for each rows. Thanks in advance

[jschell]

I think some of your post was truncated. As a guess if you are suggesting that you want to return rows from two tables where there is no common columns between them then the answer is simple - use two queries.

[Mycroft Holmes]

If you are looking for records in table 1 where A,B,C records are not in table 2 then the following should help

Select * from table1 T
where not exists(Select * from Table2 TT where T.A = TT.A and T.B = TT.B and T.C = TT.C)

Never underestimate the power of human stupidity RAH

[ptr_Electron]

Gr8 sir .. it worked .. you made my weekend :) ... I wish you a wonderfull weekend. :)