I can do an Item Alias List in Store Manager and the code listed below in Store Administrator or SQL Server Management Studio but the problem I'm running into now is that per Alias it wants to create another row. I need these to be all on the same row. Any advice on how to move each Alias into the same row for the same product?
SELECT Alias.Alias, Alias.ItemID, Item.ID, Item.ItemLookupCode
FROM Alias LEFT JOIN Item ON Alias.ItemID = Item.ID