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

[rudy]

> Umm, why have a cost column in the item table then?
> Why not just put one cost column in the item_zone table?

a valid question, and it shows that you're thinking (a basic requirement for
database design, eh)

but it's not just one column (i mean, it is, but that's not the problem)

it's multiple rows

how do you get "the" base price out of multiple rows that may all have
different prices?

what about new items added to inventory before you establish override
pricing and shipping to various zones? gotta record the base price
somewhere, so do you add an item_zone row with a null zone_id?  (ouch)


rudy