As clause in Advanced Query


Hello Everyone,

Has anyone used the 'As' clause in Advanced SQL query?

I am trying to use a self join and want to use another column as Alias.

Hi Chetan,

This should just work, but don't use the "As".

For example:

FROM {Entity1} a
    INNER JOIN {Entity1} b ON a.[Id] = b.[Id]

Kind regards,

Remco Dekkinga