bioinformatic
Technical User
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
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