ScrollMaster Posted July 26, 2006 Share Posted July 26, 2006 I have 3 TablesPostsMessageUserPosts contains a message id and a user id In order to grab the data I want do I have to make two seperate queries Post Message, Post User and then use php to match up the data or is it possible with MySQL Statements to Select all the data at once.I am unsure how to do this. Link to comment https://forums.phpfreaks.com/topic/15694-using-one-table-to-select-data-from-two-other-tables/ Share on other sites More sharing options...
fenway Posted July 26, 2006 Share Posted July 26, 2006 What are the "all data" that you want? Please clarify... in general, you can use JOINs and get back all the related records in a single pass. Link to comment https://forums.phpfreaks.com/topic/15694-using-one-table-to-select-data-from-two-other-tables/#findComment-64111 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.