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/my***********...ie.nctu.edu.tw