|
|
Posted by Ken Chau on 01/31/06 08:23
Well, that sounds like a classic case of normalized tables with a
foreign key pointing to a different table:
create table products (
id int primary key auto_increment,
product_number int
);
create table quantity_costs (
id int primary key auto_increment,
product_id int,
cost float,
quantity int
);
a simple query as below will get you your costs:
select * from products p, quantity_costs c where p.id = c.product_id;
------------
Ken Chau
http://www.gizzar.com
Navigation:
[Reply to this message]
|