report builder 10 I have a query with an inner join...error join expression not supported! In a query the report builder cannot do a join?

[kevomac12]

hey in the query builder of report builder 10 I got an error on:

FROM	tblFacility INNER JOIN tblStateProvince ON tblFacility.OIDStateProvince = tblStateProvince

what is java.swl.SQLException: [Macromedia][SequeLinkJDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported.

Why?

[EddieLotter]

You didn't provide the field from tblStateProvince to join on.

Cheers

Eddie

[kevomac12]

What I didn't find was the auto join when I double clicked two tables in to the 'builder'! From the tutorial 'creating a simple report...in CF v.9' I worked through the instructions before I tried the app for 'real'! But through the query builder I got the query to work, though without seeing the 'equal' sign I ain't sure.

[EddieLotter · Accepted solution]

The Report Builder will automatically join tables only if you have  defined a relationship between them in your database.

In Report Builder, you can easily create a join by dragging a field from one table onto the related field in the other table. It couldn't be simpler.

Cheers

Eddie

[kevomac12]

Eddie the prime programmer on this app told me that just 20 mins ago!

That's a big Dah on me.