| urgent : query not yet solved!!!!!! [message #374666] |
Sat, 23 June 2001 06:50 |
debasish
Messages: 14
Registered: January 2001
|
Junior Member |
|
|
I am having this order table:
ORDER_NO SC QTY_SUPPLIED O_DATE PC SUPPLY_DA
--------- -- ------------ --------- -- ---------
1 S1 300 12-JAN-97 P1 12-JAN-97
2 S1 200 12-JAN-97 P2 14-JAN-97
3 S1 400 15-JAN-97 P3 25-JAN-97
4 S1 200 18-FEB-97 P4 18-FEB-97
5 S1 100 22-MAR-97 P5 23-MAR-97
6 S1 100 25-MAR-97 P6 25-MAR-97
7 S2 300 28-MAY-97 P1 02-JUN-97
8 S2 400 23-JUN-97 P2 23-JUN-97
9 S3 200 23-OCT-97 P2 23-OCT-97
10 S4 200 14-NOV-97 P2 14-NOV-97
11 S4 300 18-DEC-97 P4
12 S4 400 18-JAN-98 P5 30-JAN-98
13 S5 300 18-FEB-98 P6
My query is
I want all the suppliers who r supplying all the parts supplied by scode='S2'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
