You are here: Home > Technical Articles > MS SQL Server Error - The multi-part identifier could not be bound
Solutions:
1. Make sure all the table names and column names are correct in your query.
2. In the example below, first inner join is incorrect (in red colour) as the join should be on a table1 column and not on the table3 column.
SELECT *
FROM table1 t1
INNER JOIN table2 t2 ON t2.Cust_ID = t3.Cust_ID
INNER JOIN table3 t3 ON t3.Cust_ID = t1.Cust_ID
3. If alias name of a table is incorrect
SELECT *
FROM table t1
WHERE t2.Cust_Name = 'Smith'
Published On: 04 Aug 2009
MS SQL Server Error - The multi-part identifier could not be bound
Solutions:
1. Make sure all the table names and column names are correct in your query.
2. In the example below, first inner join is incorrect (in red colour) as the join should be on a table1 column and not on the table3 column.
SELECT *
FROM table1 t1
INNER JOIN table2 t2 ON t2.Cust_ID = t3.Cust_ID
INNER JOIN table3 t3 ON t3.Cust_ID = t1.Cust_ID
3. If alias name of a table is incorrect
SELECT *
FROM table t1
WHERE t2.Cust_Name = 'Smith'
Published On: 04 Aug 2009
