Mike Spreitzer wrote:
I'm not sure whether the following will meet your needs. Have you considered SELECT title FROM Title WHERE NOT EXISTS (SELECT * FROM Keyword, TitleKeyword WHERE Keyword.kw='A' AND Keyword.id=TitleKeyword.keyword_id AND TitleKeyword.title_id=Title.id)

I believe you are right, EXISTS is what I want. Thanks,

James
--
James Fryer  /  j...@invocrown.com  /  j...@cix.co.uk

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to