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.


Table1                             Table2
item1                               other1
item2                               other2
item3                               item2
item4                               item3

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.

how can i do that? thanks

This article has been dead for over six months. Start a new discussion instead.