Hi,
I found that the problem is DISTINCT keyword. I realised that I have
no problem if I say
SELECT t.field1,t.field2 FROM table t
but error occurs if
SELECT DISTINCT t.field1,t.field2 FROM table t .
Is there a solution for that?

I have to use aliasing syntax format because I need to add another
table to
where condition (no change in columns). and still have to edit.

If there is no solution for that how to do it with DML?And where
would I put
that DML;in editsql part?

Thanks for help and quick reply.