In article <[EMAIL PROTECTED]>,
Peter Brawley <[EMAIL PROTECTED]> writes:
> Scott, sorry, my mistake,
> � SELECT price
> � FROM fedex_zones z
> � INNER JOIN fedex_rates r ON z.zone=r.zone AND z.zip=94947
> � WHERE r.weight = 25;
> PB
Although correct, many people consider this bad style - the ON clause
of the JOIN should contain only the join condition(s). So it would be
better to say
� SELECT price
� FROM fedex_zones z
� JOIN fedex_rates r ON z.zone = r.zone
� WHERE r.weight = 25
AND z.zip = 94947
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
