Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h7SCfOx22091 for ; Thu, 28 Aug 2003 07:41:24 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h7SCfN322086 for ; Thu, 28 Aug 2003 07:41:23 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h7SAA1Ml029940 for ; Thu, 28 Aug 2003 03:10:59 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h7SA0NQE028255 for oracle-l@orafaq.net; Thu, 28 Aug 2003 03:00:23 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005CDACE; Thu, 28 Aug 2003 02:59:30 -0800 Message-ID: Date: Thu, 28 Aug 2003 02:59:30 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Naveen Nahata" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Naveen Nahata" Subject: RE: SQL HELP..... Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C36D4A.29F12734" ------_=_NextPart_001_01C36D4A.29F12734 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable "Open the cartons and see!" ;-) =20 By the way can you reframe your question? Do you mean that you table = stores data as follows: =20 item carton_no qty weight ---- --------- --- ------ A 1 4 10 A 2 4 10 B 1 5 12 B 3 5 12 C 1 3 5 =20 and so on? =20 Regards Naveen -----Original Message----- Sent: Thursday, August 28, 2003 3:45 PM To: Multiple recipients of list ORACLE-L I have a table with the following columns: - item - carton_number --->(min) - carton_number --->(max) - qty --->(sum) - weight --->(sum) =20 Item A has qty of 4515 and present in cartons 1 to 1129 Item B has qty of 7255 and present in cartons 1 to 1129 Item C has qty of 400 and present in cartons 1 to 600 (???) =20 I want to find which cartons from 1 to 600 does not contain Item C. =20 Can you give me a sql/plsql script to do this.=20 =20 Thanks a lot, =20 Yoyong Cabansay Email: lbcabansay@timex.com DISCLAIMER: This message (including attachment if any) is confidential and may be = privileged. Before opening attachments please check them for viruses and = defects. MindTree Consulting Private Limited (MindTree) will not be = responsible for any viruses or defects or any forwarded attachments = emanating either from within MindTree or outside. If you have received = this message by mistake please notify the sender by return e-mail and = delete this message from your system. Any unauthorized use or = dissemination of this message in whole or in part is strictly = prohibited. Please note that e-mails are susceptible to change and = MindTree shall not be liable for any improper, untimely or incomplete = transmission. ------_=_NextPart_001_01C36D4A.29F12734 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

"Open the cartons and see!" ;-)

By the way can you reframe your question? Do you mean that you = table=20 stores data as follows:

item carton_no qty weight

---- --------- --- ------

A 1 &n= bsp; =20 4 10

A = 2 =20 4 10

B = 1 =20 5 12

B = 3 =20 5 12

C = 1 =20 3 5

and so on?

Regards
Naveen

-----Original Message-----
From: Cabansay, Yoyong=20 [mailto:lbcabansay@timex.com]
Sent: Thursday, August 28, = 2003 3:45=20 PM
To: Multiple recipients of list = ORACLE-L
Subject: SQL=20 HELP.....

I have a table with the = following=20 columns:

-=20 item

- carton_number=20    -=E0(min)

- carton_number=20    -=E0(max)

- qty =20   -=E0(sum)

- weight =20 -=E0(sum)

Item A has qty of 4515 = and present=20 in cartons 1 to 1129

Item B has qty of 7255 = and present=20 in cartons 1 to 1129

Item C has qty of 400 = and present=20 in cartons 1 to 600 (???)

I want to find which = cartons from=20 1 to 600 does not contain Item C.

Can you give me a = sql/plsql script=20 to do this.

Thanks a=20 lot,

Yoyong=20 Cabansay

Email:=20 = lbcabansay@timex.com

DISCLAIMER:
This message (including attachment if any) is = confidential and may be privileged. Before opening attachments please = check them for viruses and defects. MindTree Consulting Private Limited = (MindTree) will not be responsible for any viruses or defects or any = forwarded attachments emanating either from within MindTree or outside. = If you have received this message by mistake please notify the sender by = return e-mail and delete this message from your system. Any = unauthorized use or dissemination of this message in whole or in part is = strictly prohibited. Please note that e-mails are susceptible to change = and MindTree shall not be liable for any improper, untimely or = incomplete transmission. ------_=_NextPart_001_01C36D4A.29F12734-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: naveen_nahata@mindtree.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).