combining to fields

[djblade]

i have one table with product and id numbers and another table with serial
numbers. i need to get to products to access one serial number. how would i
do this

 

[Philip Herlihy]

i have one table with product and id numbers and another table with serial
numbers. i need to get to products to access one serial number. how would i
do this

I can't make sense of your question unless I assuem "get to products"
should be "get two products". If that's the case, then it's a table
design issue: you need to add a reference (foreign key) to the
SerialNumbers table into the Products table. If you want clear answers,
a clear question is a good place to start, though.

Phil, London