Re: possible join

[Harald Fuchs]

In article <4281B3C1.9070708@stripped>,
Peter Brawley <peter.brawley@stripped> 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