SELECT SalesPersonID ,
CASE 
WHEN SalesPersonID in
(
	SELECT SalesPersonID FROM  Sales.SalesOrderHeader 
	WHERE SalesOrderID in
	(
		SELECT SalesOrderID FROM Sales.SalesOrderDetail
		WHERE ProductID = 744
	)
)
THEN 'Make Call!'
ELSE 'Relax'
END AS Message
FROM Sales.SalesPerson;
a
b
