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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
