src/hg/lib/hgFind.c 1.225

1.225 2010/02/16 21:16:53 angie
In searchKnownCanonical, no need to include knownGene in the query because kgXref and knownCanonical can be joined directly - thanks for catching that Tim.

Index: src/hg/lib/hgFind.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/hgFind.c,v
retrieving revision 1.224
retrieving revision 1.225
diff -b -B -U 4 -r1.224 -r1.225
--- src/hg/lib/hgFind.c	10 Feb 2010 22:54:25 -0000	1.224
+++ src/hg/lib/hgFind.c	16 Feb 2010 21:16:53 -0000	1.225
@@ -2972,12 +2972,10 @@
 if (sqlTableExists(conn, "knownGene") && sqlTableExists(conn, "knownCanonical") &&
     sqlTableExists(conn, "kgXref"))
     {
     char query[512];
-    safef(query, sizeof(query), "select knownCanonical.chrom,chromStart,chromEnd,name "
-	  "from knownCanonical,knownGene,kgXref where kgXref.geneSymbol = '%s' "
-	  "and kgXref.kgId = knownGene.name and knownGene.name = knownCanonical.transcript;",
-	  term);
+    safef(query, sizeof(query), "select chrom,chromStart,chromEnd,kgID from knownCanonical,kgXref "
+	  "where kgXref.geneSymbol = '%s' and kgXref.kgId = knownCanonical.transcript;", term);
     struct sqlResult *sr = sqlGetResult(conn, query);
     char **row;
     if ((row = sqlNextRow(sr)) != NULL)
 	{