Click to See Complete Forum and Search --> : Two tables with one different coulmn or one...


weee
08-16-2004, 11:45 PM
I have a page with products and I'm getting the info from a table call prodcutsTBL. I also have a table with special products and I'm getting the info from a table call specialprodcutsTB.

My question is if I need to make two tables for products and for specils products or one with a status thing that will define wheather if product is special or not.

What will work better?

Thanks!

CardboardHammer
08-17-2004, 12:32 AM
Assuming the tables have all the same columns, you're probably better off stuffing it all in one table with an added field to indicate "special" or not.

weee
08-17-2004, 01:13 AM
?