Reference an alias variable in my SQL where clause? [duplicate]
This question already has answers here: Referring to a Column Alias in a WHERE Clause (10 answers) Closed 13 mins ago. I am working on a query that requires the use of flags from 2 different tables. I did a left join to get the columns but the alias cannot be used in the where […]
How can I reference an Alias variable in my SQL where clause?
I am working on a query that requires the use of flags from 2 different tables. I did a left join to get the columns but the alias cannot be used in the where clause.