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