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. Quote Link to comment 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. Quote Link to comment 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.