I'm trying to create a typed list (via code, not designer) to duplicate the following query:

SELECT  Table1.Field1, 
    Table1.Field2, 
    Table1.Field3, 
    EnumItem.ItemName AS Enum1Name, 
    EnumItem_1.ItemName AS Enum2Name
FROM        
    Table1 INNER JOIN
        EnumItem ON Table1.Enum1Id = EnumItem.Id INNER JOIN
        EnumItem AS EnumItem_1 ON Table1.Enum2Id = EnumItem_1.Id

I'm probably missing something small but I'm having difficulties writing this in code. Any help would be appreciated (adapter templates).

Of course as soon as I post I find the solution. When adding relations you can create the alias relation entity name.