Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Please use "dbo.search_Incident_Custom_Joined.IncidentID" instead of dbo_search_Incident_Custom_Joined.IncidentID
Hope it helps
Hi
Please use "dbo.search_Incident_Custom_Joined.IncidentID" instead of dbo_search_Incident_Custom_Joined.IncidentID
Hope it helps
dbo_search_Incident_Custom_Joined.IncidentID should probably be search_Incident_Custom_Joined.IncidentID