I have two tables
manager table has manager_id,manager_name
team table is the table which contains team member which reports to a manager in manager table.
Team table has 3 columns, manager_id, Team_member_name, Team_member_address
I need to display a result set with column Manager_name, Team_member_address.