Peter Brawley wrote:
/Now this query is run over two tables and the ab_members table contains
around 302 rows. Around 1/3 of these will be where cup=kids. However,
when this query is run it returns 20,700 results /
That's because your ...
FROM ab_leader_board ablb, ab_members abm
calls for a
Greetings All,
Please have a look at the following query:
SELECT abm.mem_number, abm.first_name, abm.last_name,
abm.area_represented, abm.age, abm.sex, abm.cup,
ablb.*, ablb.jp + ablb.rc + ablb.fsmgp + ablb.gmc + ablb.saly +
ablb.nwgp + ablb.ecgp + ablb.sams + ablb.wcc + ablb.kzngp + ablb.emc
. This has helped me determine
some additional indexes that greatly speed up my queries.
--
George
- Original Message -
From: Schalk [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 23, 2006 6:59 AM
Subject: Query returns to many results
Greetings All,
Please have
the
query. This has helped me determine
some additional indexes that greatly speed up my queries.
--
George
- Original Message - From: Schalk [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 23, 2006 6:59 AM
Subject: Query returns to many results
Greetings All
: Thursday, February 23, 2006 6:59 AM
Subject: Query returns to many results
Greetings All,
Please have a look at the following query:
SELECT abm.mem_number, abm.first_name, abm.last_name,
abm.area_represented, abm.age, abm.sex, abm.cup,
ablb.*, ablb.jp + ablb.rc + ablb.fsmgp
Again, I implore all SQL coders to use the explicit JOIN syntax on all
platforms that support it (Oracle being a well-known exception). It makes
Oracle supports the ANSI JOIN syntax from v9 and up.
Shawn Green
As for the rest, I fully agree.
Martijn Tonies
Database Workbench - development
Now this query is run over two tables and the ab_members table
contains
around 302 rows. Around 1/3 of these will be where cup=kids.
However,
when this query is run it returns 20,700 results
That's because your ...
FROM ab_leader_board ablb, ab_members abm
calls for a cross join--it
