Hi @Vivian Mattos ,

just add it a second time as source, service studio will give it the name Drink2 or something

You can click on the name an give each one a meaningfull name so your filters and code dealing with the output will be more readable

Hi Vivian,

You cannot join an entity (table) with the reference of itself. This is not a limitation of OutSystems: in SQL this is also not possible. Instead, you add another instance of the same entity (like Dorine explained). This is similar to SQL, where you would use an alias like this:

SELECT *
FROM MyTable	
INNER JOIN MyTable MyTableChild ON MyTableChild.ParentId = MyTable.Id

In an Aggregate, you do the above like this:

try add same table as source and make join as accordingly