Page 1 of 1

mysql join (many to one)

Posted: Wed Nov 16, 2011 12:42 pm
by dbecker88
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'

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";
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!