mysql NOT in stuff..
mysql NOT in stuff..
Out of context: Reply #4
- Started
- Last post
- 4 Responses
- sublocked0
should be able to get er done with a simple subquery.
SELECT *
FROM table_a
WHERE id NOT IN(
SELECT band_id
FROM table_b
);- formatting fail, but whateversublocked
- might want to change the "id NOT IN" to "band_id NOT IN". not really sure of your field names thosublocked
- I really think you've earned yourself a beer.mikotondria3
- i like red stripe. thx.sublocked
- Cshhk !... and other beer-opening onomatopoeiamikotondria3