How to join two joined tables with inner query in linque? same like below I tried in sql server
select refCustGrouped.Extension,refCustGrouped.CreatedOn,users.MobileNo,users.Name,cust.Status,users.IsDelete
from [there_crm].[therecrm_admin].[User] users
join [there_crm].[therecrm_admin].[Customer] cust on users.uID = cust.uID
join (
select top 1 with TIES refCust.cuRefID,refCust.MobileNo,
refCust.CreatedOn,refCust.Extension
from [there_crm].[therecrm_admin].[RefCustomer] refCust
ORDER BY
ROW_NUMBER() OVER(PARTITION BY refCust.MobileNo ORDER BY refCust.cuRefID DESC)
) refCustGrouped on refCustGrouped.MobileNo = users.MobileNo
where users.IsDelete Is NULL or users.IsDelete = 0 and users.rID = 3 and cust.Status = 'INV' or cust.Status = 'VIS'
Salman BegPosted Jan 9, 2019, 9:01 AM
Salman BegPosted Jan 10, 2019, 2:50 AM
dawood abbasPosted Jan 10, 2019, 1:34 AM
@Jignesh Kumar Hello,
Jignesh KumarPosted Jan 9, 2019, 9:02 AM