[thelist] SQL: Need help for query within a store
Tab Alleman
Tab.Alleman at MetroGuide.com
Fri Dec 6 10:52:01 CST 2002
Umm, why have a cost column in the item table then?
Why not just put one cost column in the item_zone table?
-----Original Message-----
From: rudy [mailto:r937 at interlog.com]
Sent: Friday, December 06, 2002 10:10 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] SQL: Need help for query within a store
> 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
item table
item_id item_name cost
24 A good book 15
zone table
zone_id zone_name
1 Continental US
2 Alaska/Hawaii
3 Canada
item_zone table
item_id zone_id shipping overridecost
24 1 4 -
24 2 6 -
24 3 5 22
rudy
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list