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

Joshua Olson joshua at waetech.com
Fri Dec 6 08:57:01 CST 2002

----- 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



More information about the thelist mailing list