select * from vOrderDetails D where OrderID = 65 select * from tblOrderReturns R where OrderID = 65
select O.OrderID,D.OrderDetailID,D.ProductName, case when R.OrderDetailID != D.OrderDetailID then '0' else '1' end ReturnItem From dbo.vOrderDetails D left outer Join tblOrders O On O.OrderID = D.OrderID left outer join tblCustomerLogins L On O.CustomerID = L.CustomerID left outer join tblOrderReturns R on R.OrderID = D.OrderID Where O.OrderID = 65 And L.SessionID ='8004837C7D62qdSV8'
tblCustomerLogins
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)