Skip to main content
kevomac12
Inspiring
Oct 13, 2015 6:19 PM UTC
Answered

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?

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?

    This topic is closed to new replies. Start a new post to keep the conversation going.
    EddieLotter
    EddieLotterCorrect answer
    Inspiring
    Oct 15, 2015 8:27 PM UTC

    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

    View reply

    4 replies

    EddieLotter
    EddieLotter
    Inspiring
    Oct 13, 2015 9:48 PM UTC

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

    Cheers

    Eddie

    Translate
    kevomac12Author
    Inspiring
    Oct 15, 2015 8:18 PM UTC

    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.

    Translate
    EddieLotter
    EddieLotterCorrect answer
    Inspiring
    Oct 15, 2015 8:27 PM UTC

    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

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices