I have combined your SQL with the one I made up myself ~
SELECT OrdNo, OrdDate FROM OrderTbl WHERE OrdNo IN (
SELECT OrdLine.OrdNo FROM OrdLine WHERE OrdLine.ProdNo IN (
SELECT Product.ProdNo FROM Product WHERE Product.ProdName LIKE '%Ink Jet%'
GROUP BY OrdLine.OrdNo HAVING COUNT(DISTINCT OrdLine.ProdNo) = 1
I know the SQL and the result are different than yours, but it fulfill my needs.
Took me at least 3 hours to come up with this SQL ~
I will be posting another question soon ~ If you experts can help me out with another one, that would be great ~~