WHERE

Hi All,

How can one use a table created for saving the results for a query be
used in WHERE for subsequent query!!!

Step 1) create table temp as select gene from dataTable1 intersect
select gene from dataTable2;

Now temp has been created, temp has only one column which has list of
genes and nothing else but i want to retrieve annotation for the genes
in temp table.

Is it possible to: select geneAnnotation from dataTable1 where genes =
"gene in temp table";!!!!!

Or am i here in some serious soup!!! :((

Thanks,
Hrishi