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
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 ...
(Essent
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,
wha