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

[rudy]

> So, if an item has three shipping zones and two pricing zones, will
> there be 6 records for this item in the item_zone table (one record
> per combination)?

show me the data for these 3 shipping zones and 2 pricing zones
and i will show you how to combine them into three zones with two columns

> The other issue is that one of the pricing zones is really a combination
> of two shipping zones.  The pricing zone of US covers the two shipping
> zones of US and Hawaii/Alaska.

yes, so the override price would be the same in both zone records

as i said, show me the sample data, it should become clear in a minute


rudy