Could somebody please take a look at the following problem for me please?
I have 2 tables, and from which I return 1 column from each...
ID ID
1 1
2 2
3 3
4 4
5 5
6
7
8
9
10
Is there a way I can run ONE query to return only the non-duplicated items? (6,7,8,9,10). Currently I'm returning both sets of results with 2 queries and running them through PHP.
Question
AnthonySterling
Hey guys,
Could somebody please take a look at the following problem for me please?
I have 2 tables, and from which I return 1 column from each...
ID ID
1 1
2 2
3 3
4 4
5 5
6
7
8
9
10
Is there a way I can run ONE query to return only the non-duplicated items? (6,7,8,9,10). Currently I'm returning both sets of results with 2 queries and running them through PHP.
Most, inefficient!
Cheers,
SilverB. :blush:
Link to comment
Share on other sites
5 answers to this question
Recommended Posts