Re: using multiple subtables efficiently

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 25 Sep 2001 18:09:27 -0700
Message-ID: <c0d87ec0.0109251709.4eec951e@posting.google.com>

>> I'm pretty much a novice at database design. <<

It shows <g>. Tables have rows and not records -- the difference is critical. There is no such term as "subtable' in SQL. And you did not post any DDL, so people trying to help you have to make stupid wild ass guesses about what you are doing.

>> Table A holds general product information and the subtables hold
product-specific information. <<

CREATE TABLE Products
(upc DECIMAL (10,0) NOT NULL PRIMARY KEY,  ...);

CREATE TABLE WetStuff
(upc DECIMAL (10,0) NOT NULL

     PRIMARY KEY 
     REFERENCES Products(upc)
     ON DELETE CASCADE
     ON UPDATE CASCADE,

 alcohol_percentage DECIMAL(5,4) NOT NULL DEFAULT 0.0000,   ...);

 Etc. Received on Tue Sep 25 2001 - 20:09:27 CDT