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)