Hello Jitka, Thank you very much for checking with us. Your query should be just fine. Feel free to use our public MySQL server for this work. For information on connecting to and working with our public MySQL server, read this FAQ: http://genome.ucsc.edu/FAQ/FAQdownloads#download29
Regards, ---------- Ann Zweig UCSC Genome Bioinformatics Group http://genome.ucsc.edu Jitka Sulcova wrote: > Hi, > > I would like to run on your public server following query but I do not > known If it is not too excessive, so I ask you If I can. > > select refLink.product, refLink.mrnaAcc, refLink.protAcc, > refLink.locusLinkId, refLink.prodName, knownToLocusLink.name, > knownToLocusLink.value, refSeqSummary.mrnaAcc, refSeqSummary.summary, > productName.id, productName.name from refLink left join knownToLocusLink > on refLink.locusLinkId=knownToLocusLink.value left join refSeqSummary on > refLink.mrnaAcc=refSeqSummary.mrnaAcc left join productName on > refLink.prodName=productName.id; > > Thank you > > Sincerely yours > > Jitka > _______________________________________________ > Genome maillist - Genome@soe.ucsc.edu > http://www.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - Genome@soe.ucsc.edu http://www.soe.ucsc.edu/mailman/listinfo/genome