Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

What to do when multi part identifier could not be bound?

Asked by Clare Matthews Mar 15, 2023 989 views 1 answer
Share

About this question

 I have 3 tables: table_a needs to communicate with table_c, but has to go to table_b first. Or put differently: table_a refers to table_b which then refers to table_c.


The relationship between the tables is defined as:


table_a.licno relates to table_b.licno

table_b.ID relates to table_c.ID

I need to retrieve 3 columns from table_c like the following:

table_c.lastname
table_c.firstname
table_c.middlename
Here's my code so far:
select firstname, middlename, lastname 
from table_c
where table_b.licno=table_a.licno 
and table_c.employeeid = table_b.employeeid;
I am receiving the following error message:

multi-part identifier could not be bound

What am I doing wrong?

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

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

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.