Hello all i am executing the following code: SELECT A.KFC_ID, A.Date_of_request, B.plc_Name_long, E.Broker_GivenName, E.Email FROM table_KFC_KFC A, table_Broker E INNER JOIN table_plc B ON A.plc_id = B.plc_id INNER JOIN table_KFC_role R ON E.Broker_ID = R.Broker_ID WHERE R.role_id IN (100, 145, 698, 775, 1) when executed the following query then i am getting the following Error: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "A.plc_id" could not be bound. please suggest how can i rectify this error.
The error means that the column '`plc_id`' is not present in the table '`table_KFC_KFC`'. Make sure that the join to '`table_plc`' is using the correct column(s). Also reconsider the query in regards to the table '`table_Broker`' - you are using the old style join syntax (is the cross join onto '`table_KFC_KFC`' desired?).