Thank you, but where would that line fit into this query:
SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderId = orderdetails.DetailOrderId
WHERE orderdetails.DetailOrderId = WADAOrderId OR ( -1= ParamOrderId AND OrderId=ParamSessionorderid)
Would I write it in the SELECT statement?