Subject RecordCount, Distinct and as-Fields
Author achidan
Hi Jason

I found another problem with RecordCount for a statement like this:

SELECT DISTINCT Fld1, Fld2 as Fld3 FROM Table1

This is transformed for the RecordCount statement as

SELECT COUNT(DISTINCT Fld1 || '.zZz.' || Fld2 as Fld3) FROM Table1

which is not working.