Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Should I use 1 or 2 tables?


Message #1 by "Arbon Reimer" <arbon_reimer@h...> on Wed, 4 Apr 2001 10:05:18 -0600
This is a multi-part message in MIME format.

------=_NextPart_000_0041_01C0BCEE.C0C0C0F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a database with two tables...
one is the Products table, each product identified with its own ID 
number...
and a Stock table, which keeps track of average prices, the amount in 
stock, and whether or not the product is on order... among other things.

Am I doing myself a disservice using two tables instead of just piling 
the information all into one table?  I thought about putting all the 
information into just one table and not relying on the ProductID as an 
index.

Thanks for your help!

Regards,
Arbon Reimer


  Return to Index