If you are using a MySQL version allowing subselects, try this: SELECT * FROM temp_hits WHERE url NOT IN(SELECT * FROM hits)
use parenthesis not brackets hope it helps Allen -----Original Message----- From: news [mailto:[EMAIL PROTECTED] Behalf Of Soren O'Neill Sent: Tuesday, August 19, 2003 2:32 PM To: [EMAIL PROTECTED] Subject: Simple error ... Im sure I keep getting a syntax error, when trying to run this query (perl script): SELECT * FROM temp_hits WHERE url NOT IN SELECT * FROM hits Ive tried with brackets around the last SELECT statement ... no better ... (Essentially, the tables hits, new_hits and temp_hits hold the same columns, what I want to do is extract any rows from new_hits, where the url field is not found in the hits table...) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]