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

[rudy]

> 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