Hi I have this two table
table 1
id Selection
-------------------
1 John
2 Ely
3 Marcus
4 Steve
5 Fritz
6 Orly
7 Carlo
8 Lee
table 2
id Selected
-------------------
1 John
3 Marcus
4 Steve
5 Fritz
7 Carlo
the return would be the unselected rows. What would be the query for this output
id Selection
-------------------
2 Ely
6 Orly
8 Lee
Use
LEFT JOIN
to join both table andt2.ID IS NULL
to remove common recordsOutput:
See this SQLFiddle