As a follow-up to this question: How to "PERFORM" CTE queries in PL/pgSQL? I try: perform (with test_as_cte as(select * from myTable) select * from test_as_cte); But get the following ...

trying this select tblPersonalInfo.companyname, tblJobBudget.title,tblJobBudget.lastmodifiedby, tblJobAdv.advtitle, tblJobAdv.userId, tblApplication.advid, tblApplication.position from tblJobAdv...