Jeasus man! I'm gonna show you something, it'll take me about an hour to
rewrite your query though!! Bare with me...
....4 hours later...
You're saying this:
SELECT tblShipOptionCountries_rel.shipoptionID,
tblShipOptionCountries_rel.ISOID,
tblShipOptions.shipoptionID, tblShipOptions.shipoptionname,
tblShipOptions.shipoptiondescription,
tblShipOptions.shipoptionbasefee,
tblShipOptions.shipoptionpercentofordercharge,
tblShipOptions.shipoptionpercentratetable,
tblShipOptions.shipoptionfreeshipamount,
tblShipOptions.shipoptionstatesonly,tblShipOptions.shipoptionmakedefault,
tblShipOptionZones.shipoptionzoneID, tblShipOptionZones.shipoptionID,
tblShipOptionZones.shipoptionzipstart, tblShipOptionZones.shipoptionzipend,
tblShipOptionRates.shipoptionzoneID, tblShipOptionRates.shipoptionID,
tblShipOptionRates.shipoptionratelow, tblShipOptionRates.shipoptionratehigh,
tblShipOptionRates.shipoptionratecharge,
tblShipOptionStates_rel.shipoptionID, tblShipOptionStates_rel.stprvID
FROM tblShipOptions INNER JOIN tblShipOptionCountries_rel
ON tblShipOptions.shipoptionID = tblShipOptionCountries_rel.shipoptionID
INNER JOIN tblShipOptionStates_rel ON
tblShipOptions.shipoptionID = tblShipOptionStates_rel.shipoptionID
INNER JOIN tblShipOptionZones ON
tblShipOptions.shipoptionID = tblShipOptionZones.shipoptionID
INNER JOIN tblShipOptionRates ON
tblShipOptions.shipoptionID = tblShipOptionRates.shipoptionID
AND tblShipOptionZones.shipoptionzoneID =
tblShipOptionRates.shipoptionzoneID
AND tblShipOptionCountries_rel.ISOID = 'US'
AND tblShipOptionZones.shipoptionzipstart <= 27403
AND tblShipOptionZones.shipoptionzipend >= 27403
AND tblShipOptionRates.shipoptionratelow <= 36.50
AND tblShipOptionRates.shipoptionratehigh >= 36.50
AND tblShipOptionStates_rel.stprvID = 33
is easier on the eye than:
SELECT
soc.shipoptionID,
soc.ISOID,
so.shipoptionID, so.shipoptionname, so.shipoptiondescription,
so.shipoptionbasefee, so.shipoptionpercentofordercharge,
so.shipoptionpercentratetable, so.shipoptionfreeshipamount,
so.shipoptionstatesonly, so.shipoptionmakedefault,
soz.shipoptionzoneID, soz.shipoptionID,
soz.shipoptionzipstart, soz.shipoptionzipend,
sor.shipoptionzoneID, sor.shipoptionID,
sor.shipoptionratelow, sor.shipoptionratehigh,
sor.shipoptionratecharge,
sos.shipoptionID, sos.stprvID
FROM tblShipOptions so
INNER JOIN tblShipOptionCountries_rel soc ON so.shipoptionID =
soc.shipoptionID
INNER JOIN tblShipOptionStates_rel sos ON so.shipoptionID = sos.shipoptionID
INNER JOIN tblShipOptionZones soz ON so.shipoptionID = soz.shipoptionID
INNER JOIN tblShipOptionRates sor ON so.shipoptionID = sor.shipoptionID
AND soz.shipoptionzoneID = sor.shipoptionzoneID
AND soc.ISOID = 'US'
AND soz.shipoptionzipstart <= 27403
AND soz.shipoptionzipend >= 27403
AND sor.shipoptionratelow <= 36.50
AND sor.shipoptionratehigh >= 36.50
AND sos.stprvID = 33
Have you been listening to TfF too loud or something?! :OD
-----Original Message-----
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 07 February 2006 00:40
To: CF-Talk
Subject: Re: Need query help
>Maybe it's just the fact that it's in an email, but that is one chunk of
>SQL! Why don't you use table alias' to shorten it some?
>
I've just never liked the way they look. They kinda mix me up.
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231550
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
