The specified alias created a reference that cannot be resolved. This error can occur, for example, if you enter the following SQL statement, in which A is the circular reference:
SELECT A + B AS C, C + D AS E, E + F AS A
FROM MyTable;
SELECT week1 + week2 as hours, hours + overtime as gross, gross + ytdpay as week1
FROM EmployeePay