1,105,585 Community Members

MySQL Query Problem

Member Avatar
dashawk
Light Poster
39 posts since Jul 2011
Reputation Points: 4 [?]
Q&As Helped to Solve: 3 [?]
Skill Endorsements: 0 [?]
 
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

Member Avatar
thines01
Postaholic
2,420 posts since Oct 2009
Reputation Points: 389 [?]
Q&As Helped to Solve: 413 [?]
Skill Endorsements: 10 [?]
Team Colleague
Featured
 
0
 

select distinct
Or
use a union and make it distict.

Can you post your full query?

Member Avatar
Reverend Jim
Noli mentula
5,464 posts since Aug 2010
Reputation Points: 770 [?]
Q&As Helped to Solve: 654 [?]
Skill Endorsements: 51 [?]
Moderator
Featured
 
1
 

You can try

select name from Table2 where name not in (select * from Table1)
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: