SQL HELP.....

I have a table with the following columns:

- item

- carton_number -à(min)

- carton_number -à(max)

- qty -à(sum)

- weight -à(sum)

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 (???)

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

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

Thanks a lot,

Yoyong Cabansay

Email: [EMAIL PROTECTED]

Reply via email to