SELECT DISTINCT prs.RiderId FROM [dbo].[PlanRiderSet] prs INNER JOIN [dbo].[PlanProductSet] pps ON prs.PlanId = pps.PlanId inner join [dbo].[PlanRider] pr on pr.Id=prs.RiderId WHERE pr.RiderIdNumber=604 /*Here I pass value like multiple means ‘604,601,605,703’ like this values are in table column values.*/ and pps.ProductId = (SELECT pps.ProductId FROM [dbo].[CustomerXref] cxref INNER JOIN [dbo].[CustomerPlanXref] cpxref ON cpxref.Id = cxref.PlanXrefId INNER JOIN [dbo].[Plan] p ON p.Id = cpxref.PlanId INNER JOIN [dbo].[PlanProductSet] pps ON p.Id = pps.PlanId WHERE cxref.PlanXrefId = 3598) ORDER BY prs.RiderId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)