ok here is it. i have two tables: products and warehouse product table consist of (pid(primary),pname,pcolor) while my warehouse table has (pid(primary foreign key=> products table), date_delivered,quantity).my question is can i display the warehouse table with pid,pname,pcolor,date_delivered and quantity since my primary key in warehouse table is the pid from products table? can i use join with these? if so how?thank you.
primary foreign key display in html table
- Thread starter dray
- Start date