hi bill
try like this --
SELECT cd.*
FROM cd
LEFT OUTER
JOIN genre
ON genre.cd = cd.id
AND genre.name = 'rock'
WHERE genre.name IS NULL
in the ON clause of the outer join, put what you're looking for (i.e.
looking for rock)
then the WHERE clause filters those out, leaving only the ones that aren't
rock
simple, innit
;o)
rudy
http://simply-sql.com/