Re: Simple error ... Im sure

2003-08-20 Thread Soren O'Neill
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

Simple error ... Im sure

2003-08-19 Thread Soren O'Neill
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