I'm not sure if I'm doing it right but ya might need a double join, like:
<cfset qContacts.LeftJoin('tblcontacts','tblcontactsource','contact')>
<cfset qContacts.LeftJoin('tblcontactsource','tblsource','source')>
I think it goes: table, table, alias...
I'm really not sure if that's how you're s'posed to chain them...
Thanks! That did the trick, with minor naming adjustments....
<cfset qContacts.LeftJoin('tblcontacts','tblcontactsource','tblcontacts')>
<cfset qContacts.LeftJoin('tblcontactsource','tblsource','tblsource')>
Its actually FromTableAlias, ToTableAlias, RelationshipAlias and as it
turns out I only needed the first join for what I need.
I think I've been going FromTableAlias, RelationshipAlias, ToTableAlias.
It does make me wonder if I should add aliases to the relationships,
so that you can tell a relationship from a table.
Any thoughts?
Stephen
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
