SELECT ap.BillDate,ap.Party,ap.Amount, apa.AmountAdjusted as amount
FROM Accounting_PendingBills ap
INNER JOIN Accounting_PendingBillsAdjusted apa
ON ap.VNumber=apa.VNumber
this query resulting in database
i have tried like this in controller
var data =
from ap in db.Accounting_PendingBills
join apa in db.Accounting_PendingBillsAdjusted on ap.VNumber equals apa.VNumber
select new {Accounting_PendingBills= ap,Accounting_PendingBillsAdjusted=apa };
but not getting values here