Field Filter in CTE

Get Help
#1

Hi Team,
This is my query Format : CTE - COMMON TABLE EXPRESSION

CTE1(),
CTE2(),
CTE3()
SELECT * FROM CTE1 JOIN CTE2 JOIN CTE3

I want to apply field filter in the outer query but it is giving error as "missing entry from table name"?
can you suggest me how to achieve this?

Thank You.

#2

That is not possible but you can do something like this since field filters won't work with an Alias

image
image2990×1224 248 KB

#3

That works , Thanks Tony.