The correlation name aliasName is specified multiple times in a FROM clause.
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The correlation name 'aliasName' is specified multiple times in a FROM clause.
Sample code
<cfquery>
SELECT *
FROM table1 tableAlias1
INNER JOIN table2 tableAlias1 ON tableAlias1.column1 = tableAlias1.column1
</cfquery>
SELECT *
FROM table1 tableAlias1
INNER JOIN table2 tableAlias1 ON tableAlias1.column1 = tableAlias1.column1
</cfquery>
Explanation
The same table alias has been used twice.
In the sample code, table1 and table2 have both been aliased tableAlias1.
In the sample code, table1 and table2 have both been aliased tableAlias1.
Submitted by Adrian Lynch on Tuesday 21 October 2008