cmaclennan Posted May 14, 2009 Share Posted May 14, 2009 Hi Guys, I'm looking for some assistance in pulling data from 2 seperate tables and im not sure how to go about it, whether i can run multiple select queries or if i need to do something else. Your help is appreciated. Thanks Link to comment https://forums.phpfreaks.com/topic/158048-how-do-i-run-multiple-select-queries-or-pull-data-from-2-tables/ Share on other sites More sharing options...
keha76 Posted May 14, 2009 Share Posted May 14, 2009 You can select data from multiple mysql tables like this: SELECT table1.column, table2.column FROM table1, table2 WHERE table1.column = table2.column Added the WHERE part mainly to show usage Link to comment https://forums.phpfreaks.com/topic/158048-how-do-i-run-multiple-select-queries-or-pull-data-from-2-tables/#findComment-833730 Share on other sites More sharing options...
cmaclennan Posted May 14, 2009 Author Share Posted May 14, 2009 Thanks a lot Link to comment https://forums.phpfreaks.com/topic/158048-how-do-i-run-multiple-select-queries-or-pull-data-from-2-tables/#findComment-833740 Share on other sites More sharing options...
keha76 Posted May 14, 2009 Share Posted May 14, 2009 No problems, glad to help out! Please mark your post as solved if it is! Link to comment https://forums.phpfreaks.com/topic/158048-how-do-i-run-multiple-select-queries-or-pull-data-from-2-tables/#findComment-834267 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.