On 9/7/06, Stephen Moretti <[EMAIL PROTECTED]> wrote:
I'm having a little trouble with a join.
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...
But that's how I'm doing it...
HIH
denny
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
