mysql join (many to one)
Posted: Wed Nov 16, 2011 12:42 pm
i have 2 tables in mysql.
TableA - unique records
TableB - many records join to each record in tableA
TableB joins to TableA via 'sub_key'
When printing results, how to I list:
TableA.AbbrevName (record1)
-----TableB.Long_Name (joined record1)
-----TableB.Long_Name (joined record2)
-----TableB.Long_Name (joined record3)
TableA.AbbrevName (record2)
-----TableB.Long_Name (joined record1)
-----TableB.Long_Name (joined record2)
TableA.AbbrevName (record3)
-----TableB.Long_Name (joined record1)
thanks!
TableA - unique records
TableB - many records join to each record in tableA
TableB joins to TableA via 'sub_key'
Code: Select all
$query = "SELECT TableB.Long_Name, TableA.AbbrevName "."FROM TableB, TableA "."WHERE TableA.FACID = '$real_facid' AND TableA.sub_key = TableB.sub_key";TableA.AbbrevName (record1)
-----TableB.Long_Name (joined record1)
-----TableB.Long_Name (joined record2)
-----TableB.Long_Name (joined record3)
TableA.AbbrevName (record2)
-----TableB.Long_Name (joined record1)
-----TableB.Long_Name (joined record2)
TableA.AbbrevName (record3)
-----TableB.Long_Name (joined record1)
thanks!