2 Replies Latest reply: Mar 14, 2013 9:36 AM by Gysbert Wassenaar RSS

    join error

      Afternoon, can anyone help with this error....

       

      I'm trying to join a couple of tables

       

      part of the script is below (this works ok as an SQL query), but I'm getting an error code

       

      SQL##f - SqlState: 37000, ErrorCode: 4104, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "dbo_search_Incident_Custom_Joined.IncidentID" could not be bound.

       

       

       

      FROM
      V_IncidentDB.dbo.search_Incident_Complaints_custom RIGHT JOIN (V_IncidentDB.dbo.search_Incident_IncidentTypes INNER JOIN
      V_IncidentDB.dbo.search_Incident_Custom_Joined ON
      search_Incident_IncidentTypes.IncidentID = dbo_search_Incident_Custom_Joined.IncidentID) ON
      search_Incident_Complaints_custom.IncidentID = search_Incident_IncidentTypes.IncidentID

       

       

      any ideas

      Thanks