Answers.Body: <p>The table is <code>civicrm_entity_tag</code>; make sure you use a WHERE or JOIN to ensure that entity_table = 'civicrm_contact'.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-27T13:43:52.790Z
Answers.Text: Hi Jon,Thanks you Jon, Please what is the consequence of not specifying civicrm contact in the where clause? Does it then provide the pull tages for all other modules in civi such as civicontribute, event, campaign, etc
Answers.UserDisplayName: Edward
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-23T20:23:36.780Z
Answers.LastActivityDate: 2015-07-23T20:23:36.780Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>If you are only pulling the list of tags per individual.., check out the search builder; /civicrm/contact/search/builder?reset=1</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-23T20:06:03.583Z
Answers.LastActivityDate: 2015-07-23T20:06:03.583Z
Answers.UserDisplayName: Kboy
Body: <p>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.</p>
  
  <p>Thanks in advance</p>
  
  <p>Regards</p>
  
  <p>Edward </p>
  
Tags: <tags>
Title: How to retriev tag information via sql
ThreadText: # How to retriev tag information via sql
  
  (Asked by: username_0 on 2015-07-23)
  
  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
  
  username_0
  
  **Tags:** tags
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-07-23. Score: 2
  
  The table is `civicrm_entity_tag`; make sure you use a WHERE or JOIN to ensure that entity\_table = 'civicrm\_contact'.
  
  > **Comments:**
  > **username_0**: Hi Jon,Thanks you Jon, Please what is the consequence of not specifying civicrm contact in the where clause? Does it then provide the pull tages for all other modules in civi such as civicontribute, event, campaign, etc  
  
  ---
  
  ### Answer by username_2 on 2015-07-23. Score: 0
  
  If you are only pulling the list of tags per individual.., check out the search builder; /civicrm/contact/search/builder?reset=1
  
  
  ---
  
  