create table products (
 prod_id int primary key,
 model_num int );

create table prod_desc (
 prod_id int foreign key,
 desc text );

SELECT desc FROM products p, prod_desc d WHERE p.prod_id = d.prod_id AND p.prod_id = ?;