[thelist] SQL: Need help for query within a store

[Joshua Olson]

----- Original Message -----
From: "rudy" <r937 at interlog.com>
Sent: Friday, December 06, 2002 9:46 AM


> > So, if an item has three shipping zones and two pricing zones, will
> > there be 6 records for this item in the item_zone table (one record
> > per combination)?
>
> show me the data for these 3 shipping zones and 2 pricing zones
> and i will show you how to combine them into three zones with two columns

Sample Item
~~~~~~~~~~

Item name: "A good book"
Shipping to Continental US: 4
Shipping to Alaska/Hawii: 6
Shipping to Canada: 5
US Price: 15
Canadian Price: 22

Thanks

-joshua