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! Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/274278-mysql-query/#findComment-1411461 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.