drew_caplan Posted February 10, 2013 Share Posted February 10, 2013 Hello, I am teaching myself new php/mysql skills and I have a questions on how do I look up data from one table that references another? For instance I am able to query a table and pull all my data and one of my columns is "customer_id" which is a reference to another table that have the columns "id" and "name". So my question is how do I pull the "name" from that table where "customer_id" is equal to the "id" from the customers table"? Thank you in advance! Link to comment https://forums.phpfreaks.com/topic/274278-mysql-query/ Share on other sites More sharing options...
Jessica Posted February 10, 2013 Share Posted February 10, 2013 Inner/left join. Moving this to mysql section. Link to comment https://forums.phpfreaks.com/topic/274278-mysql-query/#findComment-1411461 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.