> Kinda weird, but try like so > > SELECT A.Name, B.Cost > FROM tableA a > INNER JOIN tableB b > ON (A.ID = B.aID) > WHERE B.aID = 1
I don't have an MX machine handy ... curious to know what the error message was tho... could you post it to the list? Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
