[Genome] mysql intersect query

[Dave Smith]

Hello

I would like replicate the intersect queries that are performed by your table browser but instead use the public access mysql server.

The type of intersect queries I am interested would be like these two (for human):

All Known Genes records that have any overlap with SNPs
All Known Genes records that have no overlap with SNPs 

I would be most grateful if you could provide me with the exact mysql queries that are used to produce this data in the table browser. I hope you can help and many thanks for providing the excellent browser!

Dave

____________________________________________________________
ONE-CLICK WEBMAIL ACCESS - Easily monitor & access your email accounts!
Visit http://www.inbox.com/notifier and check it out!