How to Export All Teams Associated with Records in SugarCRM?

Question

Hello everyone, 
 I'm trying to export all the teams associated with records in SugarCRM. For example, one of my accounts is linked to two teams: Global and QMob-13 . 
 
 When I try to export this kind of information using standard reports, I only get the primary team or the private one, which usually just gives me the Global team. 
 
 I&rsquo;ve also tried using advanced reports, but without success. 
 Here&rsquo;s the SQL query I used:

SELECT team_set_id, acl_team_set_id, team_set_id FROM accounts WHERE billing_address_postalcode LIKE '13%';

Unfortunately, this doesn&rsquo;t return all the teams associated with each account as I was hoping. (yeah, i know that i did choose only the fields available on "accounts" tables so that's why my query doesn't work)... 
 Has anyone encountered this before or have any suggestions on how to retrieve all associated teams for each record? Thanks in advance for your help, and have a great evening!

Phuong Trinh · Answer

The Team Set is comprised of teams, the IDs of those teams are found in the teams_sets_teams and then you have to look up the teams names in the teams table to make sense of it. 
 select accounts.team_set_id, teams.name, teams.private
from acounts
join team_sets_teams on team_sets_teams.team_set_id = accounts.team_set_id and team_sets_teams.deleted = 0
join teams on teams.id = team_sets_teams.team_id and teams.deleted = 0
where accounts.deleted = 0
and ... 
 To get the primary Team's name 
 select accounts.team_id, teams.name
from accounts
join teams on teams.id = accounts.team_id and teams.deleted = 0
where accounts.deleted = 0
and ... 
 Hope this helps. 
 FrancescaS