The multi-part identifier "tableAlias.columnName" could not be bound
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "tableAlias.columnName" could not be bound.
Sample code
<cfquery>
SELECT tableAlias.columnName
FROM table
WHERE tableAlias.columnName = 1
</cfquery>
SELECT tableAlias.columnName
FROM table
WHERE tableAlias.columnName = 1
</cfquery>
Explanation
The table alias wasn't specified:
FROM table tableAlias
FROM table tableAlias
Submitted by Adrian Lynch on Tuesday 28 October 2008