[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