you need to use a join query to display the related data.
See the following site for details on joined queries:
sql_join.asp
if you need help creating the syntax for the join query, a tool like Navicat is a great addition:
mysql_overview.html
it has a visual interface for creating complex queries.