hi all,
I have two tables details and details_new. Both table contains data. i have to select the data which is in details table and not in details_new table. How to write the query for geting this.?
tried like this
select dt.name
from details dt, details_new dtnm
where dt.name != dtnm.name