Thanks to all,
As you says me, the solution was the indexes. I didn't have an index
in results.sample_id. Now the query returns succesfully in a few
seconds, regards
Juan P. Espino
On 7/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Juan Pablo Espi
Hello all!
I have two tables in my database: results(20 000 rows) and
data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
I need to find the samples of data_lab1 table that they are not in
results table.
I think the following query is the solution:
SELECT data_lab1.sample_id,
