James Brown wrote:
>
> <CFQUERY name="thinglist" datasource="mydata">
> SELECT
> tblThing.ThingKey,
> tblThing.ThingName,
> tblColor.ColorDescription,
> tblCategory.CatDescription,
> tblMaker.MakerName
>
> FROM
> tblThing,
> tblColor,
> tblCategory,
> tblMaker
>
> WHERE
> tblColor.ColorKey = tblThing.ColorKey
> AND tblCategory.CatKey = tblThing.CatKey
> AND tblMaker.MakerKey = tblThing.MakerKey
>
> </CFQUERY>
<CFQUERY name="thinglist" datasource="mydata">
SELECT
tblThing.ThingKey,
tblThing.ThingName,
tblColor.ColorDescription,
tblCategory.CatDescription,
tblMaker.MakerName
FROM
tblThing
NATURAL JOIN tblColor
NATURAL JOIN tblCategory
NATURAL JOIN tblMaker
WHERE
table.field = value
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
