wannabephpdude Posted October 28, 2010 Share Posted October 28, 2010 I have a table called 'intake'... I need every field in this table (23 fields). This table has a field named rec_id. The second table is named 'insurance'... I need only one field from it named 'claim_type'. 'intake.rec_id' = 'insurance.intake_id'... How can I join them with all the 'intake' field values available and add to it the one 'insurance.claim_type'? Thanks in advance... My join skills seem to be slipping Quote Link to comment https://forums.phpfreaks.com/topic/217060-bit-of-trouble-with-join-mysql-query/ Share on other sites More sharing options...
objnoob Posted October 28, 2010 Share Posted October 28, 2010 All columns belonging to the joined tables are available. You can choose which columns are returned with the SELECT clause. SELECT table1.column2, table1.column3, table2.column5, table2.column6 FROM table1 JOIN table2 ON table1.column1 = table2.column1 Quote Link to comment https://forums.phpfreaks.com/topic/217060-bit-of-trouble-with-join-mysql-query/#findComment-1127545 Share on other sites More sharing options...
wannabephpdude Posted October 28, 2010 Author Share Posted October 28, 2010 objNoob, Thanks bro. I figured it out. Thanks to P2000 for moving this to the appropriate thread. Peace Quote Link to comment https://forums.phpfreaks.com/topic/217060-bit-of-trouble-with-join-mysql-query/#findComment-1127548 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.