Doesn't work, get the message: "the correlation name NATURAL is specified multiple times in a FROM clause"
What I don't understand is - if the tables are structured in SQL Server as being related by those fields, why SQL server doesn't just "know" what the relationships are without my having to specify it. Much of my prior experience was with xBase and once tables were related to each other, all one had to do was specify the field name in the child table and the correct related record was selected. James Brown > > <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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
