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]