tag:blogger.com,1999:blog-30379699.post2455767929161874279..comments2023-02-20T16:25:34.686+00:00Comments on Caroline Mockett: Subquery Problems in mySQLCaz Mocketthttp://www.blogger.com/profile/10460489611014669888noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-30379699.post-44763412734853333272007-10-08T11:10:00.000+00:002007-10-08T11:10:00.000+00:00its not often we find people who understand these ...its not often we find people who understand these issues and feel as passionately about them as you. Thank you. From <BR/><BR/>your friends at <A HREF="http://www.UnixCommerce.com" REL="nofollow">Unix Commerce Web Design</A>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-30379699.post-55356696645299269402007-10-04T17:53:00.000+00:002007-10-04T17:53:00.000+00:00Thanks Matt, that sorted the problem nicely - I ow...Thanks Matt, that sorted the problem nicely - I owe you a pint at the next Pubstandards ;-)Caz Mocketthttps://www.blogger.com/profile/10460489611014669888noreply@blogger.comtag:blogger.com,1999:blog-30379699.post-58391366228914214642007-10-04T17:23:00.000+00:002007-10-04T17:23:00.000+00:00I cant test this right now but try:select * from k...I cant test this right now but try:<BR/><BR/>select * from keywords kw where kw.keywdid NOT IN<BR/>(Select ka.keywdid from keywordsinarticle ka left join keywords k on ka.keywdID = k.keywordID where ka.articleID = 1) <BR/><BR/>mattAnonymousnoreply@blogger.com