skidmark10 Posted August 18, 2011 Share Posted August 18, 2011 Hello, I am trying to select more than two mysql tables using php. All of the tables have one column in common "Client_ID". Does anyone know how I would pull information from all the columns with the same "Client_ID"? I don't have a code I'm working with yet, I'm stumped. Quote Link to comment https://forums.phpfreaks.com/topic/245079-selecting-more-than-two-mysql-tables-tables-using-php/ Share on other sites More sharing options...
fenway Posted August 18, 2011 Share Posted August 18, 2011 You mean a JOIN? Quote Link to comment https://forums.phpfreaks.com/topic/245079-selecting-more-than-two-mysql-tables-tables-using-php/#findComment-1258870 Share on other sites More sharing options...
skidmark10 Posted August 18, 2011 Author Share Posted August 18, 2011 You mean a JOIN? Yes I mean "JOIN". Sorry I am new to this. Quote Link to comment https://forums.phpfreaks.com/topic/245079-selecting-more-than-two-mysql-tables-tables-using-php/#findComment-1258888 Share on other sites More sharing options...
fenway Posted August 18, 2011 Share Posted August 18, 2011 SELECT table2 INNER JOIN table2 USING ( ClientID ) Quote Link to comment https://forums.phpfreaks.com/topic/245079-selecting-more-than-two-mysql-tables-tables-using-php/#findComment-1259078 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.