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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
