I sent this to someone else who replied off list... here it is for the rest of you :)
SELECT X.whatever, Y1.fieldvalue AS 'extra field 1', Y2.fieldvalue AS 'extra field 2' (more fields if necessary) FROM TableX X LEFT OUTER JOIN TableY Y1 ON x.something = y1.something (whatever join criteria you need) LEFT OUTER JOIN TableY Y2 ON (same criteria, y2 for y1, etc) (repeat as necessary) WHERE (whatever criteria you need on TableX) In my case, I have a varying number of "Y" table calls, depending on how many different types of data I'm using, so I've got a few loops in my code that builds up the SQL code. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
