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 join | Scott Haneda | 11 May |
• Re: possible join | Peter Brawley | 11 May |
• Re: possible join | Scott Haneda | 11 May |
• Re: possible join | mfatene | 11 May |
• Re: possible join | Peter Brawley | 11 May |
• just hi | Unknown Sender | 11 May |
• Re: just hi | Johan Höök | 11 May |
• Re: possible join | Harald Fuchs | 11 May |
• Re: possible join | SGreen | 11 May |
• Re: possible join | Peter Brawley | 11 May |
• Re: just hi | Nestor Florez | 11 May |