List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:May 11 2005 1:09pm
Subject: Re: possible join
View as plain text  
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

Thread
possible joinScott Haneda11 May
  • Re: possible joinPeter Brawley11 May
    • Re: possible joinScott Haneda11 May
      • Re: possible joinmfatene11 May
      • Re: possible joinPeter Brawley11 May
      • just hiUnknown Sender11 May
        • Re: just hiJohan Höök11 May
      • Re: possible joinHarald Fuchs11 May
        • Re: possible joinSGreen11 May
        • Re: possible joinPeter Brawley11 May
Re: just hiNestor Florez11 May