Linq Union join multiple tables and select multiple columns.

Question

Below query facing issue selecting multiple columns.   var relSite = (from d in _context.Account join c in _context.AccountRel on d.ID equals c.RelID join s in _context.AccountType on c.PrelID equals s.ATypeID where c.ARelID == accountid && s.Type == "Test" select a.ID) .Union var relSite = (from d in _context.Account join c in _context.AccountRel on d.ID equals c.RelID join s in _context.AccountType on c.PrelID equals s.ATypeID where c.ARelID == accountid && s.Type == "Test" select a.ID)

San · Answer

Select statement i want other table fields also like  select a.ID,c.Name,s.Type   but there is showing error.

Ramesh Palanivel · Answer

Hi sandeep,   Did you get any error or no results? Could you please explain your problem briefly? so that people can able to understand and help you. :)