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

Joshua Olson joshua at waetech.com
Fri Dec 6 11:00:00 CST 2002


----- Original Message -----
From: "Tab Alleman" <Tab.Alleman at MetroGuide.com>
Sent: Friday, December 06, 2002 11:01 AM


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

I guess in case there is no zone defined for an item?  I can envision a
system where the zoning is considered "advanced" and the basic install of
the system may not necessarily employ that feature.  Having the cost in the
item table makes it stand-alone if necessary.

-joshua




More information about the thelist mailing list