mrt003003 Posted May 11, 2011 Share Posted May 11, 2011 Hi there im just trying to understand how to compare and output results in a table. For example lets say i have the following table: Beans ID Type Location And say 3 records: 1 Baked kitchen 2 Runners Garage 3 Broad Kitchen I want to select only the beans that have matching locations and output the Type: Baked, Broad. I'm trying to get my head around how to work this out, if you could nudge me in the right direction that would be excellent. Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/236145-basic-example-matching-records/ Share on other sites More sharing options...
fenway Posted May 13, 2011 Share Posted May 13, 2011 You're looking for a JOIN on the 'location' column. Quote Link to comment https://forums.phpfreaks.com/topic/236145-basic-example-matching-records/#findComment-1214958 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.