>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

Yes indeed but here the 'zip' condition is in the join for the possibility that the constant zip condition could speed up the join. See Shawn's excellent response.

PB

-----

Harald Fuchs wrote:
In article <4281B3C1.9070708@earthlink.net>,
Peter Brawley <peter.brawley@earthlink.net> 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