Posted by Jens on 01/13/06 02:23

Hi again,

this should be something like:

SELECT COUNT(*) From Orders O
WHERE EXISTS
(
SELECT * FROM Orderdetails OD
WHERE O.OrderID = OD.OrderId
)

HTH, Jens Suessmeyer.

[Back to original message]