I am working on a report and part of the requirement is to have pull the list of tags per individuals, households and organizations. I was able to pull the groups by using civicrm_group_contact and civicrm_group tables and join by id. I see a table in civi called civicrm_tag, it contains list of tags but I don't know how to connect it with the associated records or identify the people assigned to theses tags.
Thanks in advance
Regards
Edward