I have problem in retriveing matches data from two data base.I m using coldfusion MX .Databases are access and sql.
This is my example coding
<cfquery name="test" datasource="db1">
Select call_key,description from db1
<cfquery name="test1" datasource="db2">
Select cso,model from db2
So far it is working.
Problem started here.
I want to retrive those records from two database where call_key and cso are matching.
<cfquery dbtype="query name="result">
Select test.*,test1.* from test,test1 inner join test
Above coding is not working..
Query Of Queries syntax error.
Do you have any idea of this?Any alternative ways?