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.

• Next in forum: Requirement for- ATG Dynamo Developer at Minneapolis, MN
• Prev in forum: Re: SQL Query
• Thread view: Re: SQL Query

[Reply to this message]