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:

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

Kind regards,

Remco Dekkinga