0

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.

Example:

Table1                             Table2
item1                               other1
item2                               other2
item3                               item2
item4                               item3

Condition:
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

3
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by Reverend Jim
Featured Replies
0

select distinct
Or
use a union and make it distict.

Can you post your full query?

Edited by thines01: clarity

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.