Access Database and ColdFusion

[RosieGp]

I'm trying to retrieve data from Access DB sitting in coldfusion server but it won't return any data...

Query:

<cfquery datasource="MasterDB" name="AccessQRY">

     Select Employee.Emp_Name, Salary.Emp_ID

     From Employee inner join Salary on (Employee.ID = Salary.ID) AND (Employee.SectionName = Salary.SectionName);

</cfquery>

<cfdump var = "#AccessQRY#">

Is something wrong with my query...

[Dan_Bracuk]

All I could see wrong with your query is the semi colon at the end.  You don't want those in cfqueries.

What happens when you run the same sql inside Access?

[RosieGp]

it just worked... thanks for the semicolon catch though...