This is actually just a question on how to do a query in MySQL.
I want to do the following:
select Table1.Something from Table1 where Table1.Something not in Select Table2.Something from Table2
Of course there are no subselects in MySQL so this is not a valid query.
Basically I want all the elements from 1 list that are not already in another list.
Without subselects... this seems rather difficult. Any insight?
I want to do the following:
select Table1.Something from Table1 where Table1.Something not in Select Table2.Something from Table2
Of course there are no subselects in MySQL so this is not a valid query.
Basically I want all the elements from 1 list that are not already in another list.
Without subselects... this seems rather difficult. Any insight?