would
cause some VERY weird join results, and may be your problem. Try adding in
the join clause in the where clause.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 2:52 PM
Subject: RE: Help needed with
Okay, here is the full monty from the database regarding the query in
question, any suggestions on how to improve any of it are greatly
appreciated!
Also, if any more info is needed, just let me know.
Thanks!
Bryan
QUERY:
mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
ou did an EXPLAIN on that query and sent that.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 1:20 PM
Subject: Help needed with Query
> I am working on a mysql database with many large tables (1.5 m
hth.
-ravi.
-Original Message-
From: Bryan Coon [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 4:20 PM
To: '[EMAIL PROTECTED]'
Subject: Help needed with Query
I am working on a mysql database with many large tables (1.5 million rows on
some) and came across a beeg problem.
I h
I am working on a mysql database with many large tables (1.5 million rows on
some) and came across a beeg problem.
I have need for a query like this:
mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as
