2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>: > I am moving some code that was developed against MySQL 4.1 to a server > with 3.23, and I have one query that uses a subquery. I'm having a bear > of a time wrapping my mind around how to convert this. The original > query is this: > > SELECT page.page_id, page.page_keyword > FROM page > WHERE page.page_id<>6 > AND page.page_id > NOT IN ( > SELECT page_links.child_id > FROM page_links > WHERE page_links.page_id=6 )
With some minimal test data, this seems to work, at first sight: SELECT page.page_id FROM page LEFT JOIN page_links ON page_links.child_id=page.page_id WHERE (page_links.page_id <> 6 OR page_links.page_id IS NULL) AND page.page_id <> 6 JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
