Building an exclusive query ... everything but

[bioinformatic]

Hi All,

I have two tables. Table 1 contains a list of 200 genes and table 2 contains a list of 23200 genes including the 200 genes from Table 1. The 200 genes are all over the place in the list of 23200 genes in Table 2. I would like to build a query that displays all of table 2 without table 1 genes. I've looked at join properties but I can't figure out how to display only Table 2 genes minus genes matching up in Table 1.

I appreciate any help given.

Thanks,
Randy

 

[papparuff]

Your SQL statement will be something like this:

SELECT Table2.Gene
FROM Table1 RIGHT JOIN Table2 ON Table1.Gene = Table2.Gene
WHERE (((Table1.Gene) Is Null));

John Ruff - The Eternal Optimist

 

[bioinformatic]

Thanks John,

It works. Thanks for your help.

-Randy