Victoria Reznichenko wrote:
> "Soren O'Neill" <[EMAIL PROTECTED]> wrote:
>> 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 bette
"Soren O'Neill" <[EMAIL PROTECTED]> wrote:
> 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 ...
>
Subselects are supported in v
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
