Hi ,
If you need to eliminate some(selected)results( from another select statement) of a select statement ,
Check whetherLeft Join Helps You
Join the tables using some criteria
Then in Where Clause give Conditions as in Select statement 1
and negative conditions (opposite ) conditions from Select statement two.
SELECT <table1.required fields> FROM
table1,table2
WHERE <join condition> i.e,using which key(s) you are joining)
AND <condition to be given in SELECT statement1>
AND <negated conditions to be given in SELECT statement 2>
Hope this helps ....
(If you use same table then give alias name for atleast once)
Regards,
Ram.
We Learn the Most When we have to Invent