join error

[#1]

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

[MayilVahanan · Accepted solution]

Hi

Please use "dbo.search_Incident_Custom_Joined.IncidentID" instead of dbo_search_Incident_Custom_Joined.IncidentID 

Hope it helps

[Gysbert_Wassenaar]

dbo_search_Incident_Custom_Joined.IncidentID should probably be search_Incident_Custom_Joined.IncidentID