SQL Widget error: two objects with the same exposed names

Okay this is pretty straightforward, what's going on here? (This is my first advanced sql query) 

Hi Lucca,

Without more detail, my guess is that you are referencing the same table more than once without using alias.

For example, the following query will not work:

SyntaxEditor Code Snippet

SELECT      {Manager}.[Id]
FROM        {Manager}
LEFT JOIN   {Manager}   on  {Manager}.[SubManagerId]    =   {Manager}.[Id]

But if you add an alias in the Manager entity, the query will work:

SyntaxEditor Code Snippet

SELECT      Manager.[Id]
FROM        {Manager}   Manager
LEFT JOIN   {Manager}   SubManager  on  Manager.[SubManagerId]    =   SubManager.[Id]

Best regards!