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. 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. Link to comment https://forums.phpfreaks.com/topic/236145-basic-example-matching-records/#findComment-1214958 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.