Are you talking about doing something like: <cfquery datasource="#prefs.dsn#" name="header"> select h.id, h.header, f.state, f.sort, l.link, l.link_title from headers h left join fusion f on f.sub_object = l.headerid left join link l on f.linkID = l.linkID </cfquery>
You can join to an already joined table. Just think of it as Table1 JOIN Table2 is a whole new table. Then the next join joins to that new table. Or maybe I'm just missing something. <g> Ben Johnson Hostworks, Inc. ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists