Skip to main content
K
kevomac12
Inspiring
October 13, 2015
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?

  • October 13, 2015
  • 1 reply
  • 711 views

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 has been closed for replies.
    Correct answer EddieLotter

    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

    1 reply

    EddieLotter
    EddieLotter
    Inspiring
    October 13, 2015

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

    Cheers

    Eddie

    K
    kevomac12Author
    Inspiring
    October 15, 2015

    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
    EddieLotterCorrect answer
    Inspiring
    October 15, 2015

    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

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