How to resolve the error, SQL Server INNER JOIN multi-part identifier could not be bound [closed]

1.5K Asked by ankur_3579 in Salesforce , Asked on Jul 10, 2021

I have the following statement where selecting 2 tables from a different server and doing inner join but getting multi-part identifier could not be bound.

select * from [SQ05].[mov].[dbo].[item_movement] inner join [SQ05].[mov].[dbo].[item_master] on [SQ05].[mov].[dbo].[item_movement].[item_id] = [SQ05].[mov].[dbo].[item_master].[item_id] Msg 4104, Level 16, State 1, Line 12 The multi-part identifier "SQ05.mov.dbo.item_movement.item_id" could not be bound. Msg 4104, Level 16, State 1, Line 12 The multi-part identifier "SQ05.mov.dbo.item_master.item_id" could not be bound.

Why getting error “sql server the multi-part identifier could not be bound”.

Answered by Ankur vaish

To resolve this error: Use simple ALIAS

  select * from [SQ05].[mov].[dbo].[item_movement] AS imo inner join [SQ05].[mov].[dbo].[item_master] AS ima on imo.[item_id] = ima.[item_id]

How to resolve the error, SQL Server INNER JOIN multi-part identifier could not be bound [closed]

Your Answer