| 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> |
|---|---|---|
| ||
| Previous by Date: | Re: session in browser, SafariTECH |
|---|---|
| Next by Date: | Re: Tables in different datsources, Daverms |
| Previous by Thread: | CFHTTP Connection failure, nick |
| Next by Thread: | Re: Tables in different datsources, Daverms |
| Indexes: | [Date] [Thread] [Top] [All Lists] |