How do I get rid of this error Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query
Here is a copy of my code. I am not sure waht I am doing wrong here. Thaks!
SELECT "effective date", actioncount1 = (SELECT COUNT("Name") from "WRITTEN/NOT WRITTEN TRACKER" T1 WHERE T1."EFFECTIVE DATE" = "WRITTEN/NOT WRITTEN TRACKER"."EFFECTIVE DATE" AND MONTH("Effective Date")=(MONTH(GETDATE())-1)), actioncount2 = (SELECT COUNT("Name") from "WRITTEN/NOT WRITTEN TRACKER" T2 WHERE ("WR/NW"='WR') AND MONTH("Effective Date")=((MONTH(GETDATE())-1)) AND T2."EFFECTIVE DATE" = "WRITTEN/NOT WRITTEN TRACKER"."EFFECTIVE DATE") FROM "WRITTEN/NOT WRITTEN TRACKER" GROUP BY "effective date"