Simple Query problem

From: Wes (wesoharrison_at_hotmail.com)
Date: 02/14/05


Date: Mon, 14 Feb 2005 03:29:24 -0800

Sample table as follows

Order ID Stock Code Status
--------- ------- -------
203 STK1 3
203 STK2 2
203 STK4 3
204 STK1 3
204 STK5 3
205 STK2 2
205 STK1 3

I want a query that will return the order id when ALL
ORDER LINES are of Status 3.

i.e. from the sample above, the only table that has ALL
LINES with a status of 3 is Order 204.

Thanks,
Wes