multi-part identifier could not be bound


I have 3 tables, table_a needs to communicate with table_c but have to go to table_b first… table_a refers to table_b which then refers to table_c…

table_a.licno relates to table_b.licno table_b.ID relates to table_c.ID

I need 3 columns on table_c like the table_c.lastname,table_c.firstname,table_c.middlename