Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Salesforce
  3. Question
Salesforce

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

Asked by Ankur Vaish Jul 10, 2021 2.7K views 1 answer
Share

About this question

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”.

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest Salesforce Blogs

Guides, tips and career advice on Salesforce from JanBask experts.