Are these two datasources on the same server? Which DBMS?
Using SQL Server, I use a dot-dot notation to refer to other databases
on the same server:
STUFF is the datasource known to ColdFusion and it has a table named
"stuff". OtherStuff is a database on the same server that has a table
named "moreStuff"
..
<cfquery datasource="stuff" name="stuff">
SELECT s.field1, t.field2, t.field3
FROM stuff s
INNER JOIN OtherStuff..moreStuff t on s.field = t.field
</cfquery>
Eric Hoffman wrote:
>Is there such a beast that is pretty concise?
>
>I have a app that needs to query some data from an external datasource now.
>Just looking at theory:
>
>So, I query our data.
>
>Then query their data.
>
>Then query what? A query of queries or something?
>
>Or shortcuts?
>
>Thanks!
>
>Eric
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218093
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
