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:ne...@sea.gmane.org]On Behalf Of Soren O'Neill
Sent: Tuesday, August 19, 2003 2:32 PM
To: mys...@lists.mysql.com
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...)
4 messages in com.mysql.lists.mysqlRE: Simple error ... Im sure
