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
>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 a
> 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
queries.
> >
> > --
> > George
> >
> >
> > - Original Message - From: "Schalk" <[EMAIL PROTECTED]>
> > To:
> > Sent: Thursday, February 23, 2006 6:59 AM
> > Subject: Query returns to many results
> >
> >
>
on the way mysql is running the
query. This has helped me determine
some additional indexes that greatly speed up my queries.
--
George
- Original Message - From: "Schalk" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 23, 2006 6:59 AM
Subject: Query returns to many resu
s running the
query. This has helped me determine
some additional indexes that greatly speed up my queries.
--
George
- Original Message -
From: "Schalk" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 23, 2006 6:59 AM
Subject: Query returns to many results
Greet
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
