guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed.
if we use this query: select * from Table1 the items from Table1 will appear but if the items of Table1 exists in Table2 then i must not be displayed.
select * from Table1
how can i do that? thanks
use a union and make it distict.
Can you post your full query?
You can try
select name from Table2 where name not in (select * from Table1)