macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Tables in different datsources

Subject: Tables in different datsources
From: "trojnfn" <webforumsuser@xxxxxxxxxxxxxx>
Date: Fri, 30 Nov 2007 06:34:28 +0000 (UTC)
Newsgroups: macromedia.coldfusion.cfml_general_discussion

I have one query :
 <cfquery name="qry1" datasource="datasource1">
 select payroll_no
 from table_1
 </cfquery>

 I have this second query :
 <cfquery name="qry2" datasource="datasoruce2">
 select payroll_no,employee_name
 from table_2
 </cfquery>

 If I want to find the employee_name, I need to joint table_1 to table_2 via 
the payroll_no. But since the tables are in different databases, what is the 
proper syntax to make the join/linkages ?

 Thanks


<Prev in Thread] Current Thread [Next in Thread>