You can use the
CASE
as you have tried. Sommthing like:
select O.OrderID,D.OrderDetailID,ProductName,
case
when D.OrderDetailID != R.OrderDetailID then '1'
else '0'
end as ColName
From dbo.vOrderDetails D
Join tblOrders O On O.OrderID = D.OrderID
Join tblCustomerLogins L On O.CustomerID = L.CustomerID
join tblOrderReturns R On R.OrderDetailID = D.OrderDetailID
Where O.OrderID = 65
And L.SessionID ='8004837C7D62qdSV8'
For details see
CASE (Transact-SQL)[
^]