Having a ClientDataset, a Provider and a PgQuery with FetchAll=false, along with 2 tables, the following query failed with an error with the text similar with the title.
- with tbl as (Select 'ABC' VAL)
select a.ID, tbl.VAL
from tbl1 a
join tbl2 b on a.ID=b.ID, tbl