Simple Query problem
From: Wes (wesoharrison_at_hotmail.com)
Date: 02/14/05
- Next message: Hugo Kornelis: "Re: Simple Query problem"
- Previous message: shif: "RE: err"
- Next in thread: Hugo Kornelis: "Re: Simple Query problem"
- Reply: Hugo Kornelis: "Re: Simple Query problem"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Hugo Kornelis: "Re: Simple Query problem"
- Previous message: shif: "RE: err"
- Next in thread: Hugo Kornelis: "Re: Simple Query problem"
- Reply: Hugo Kornelis: "Re: Simple Query problem"
- Messages sorted by: [ date ] [ thread ]