Hi

I can't know your db structure.

But I think you can get how to use join in w3cschool:

http://www.w3schools.com/sql/sql_join.asp

http://www.tizag.com/sqlTutorial/sqljoin.php