[thelist] SQL: Need help for query within a store
rudy
r937 at interlog.com
Fri Dec 6 09:11:05 CST 2002
> 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
More information about the thelist
mailing list