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