title: Joining tables on an array with string
body: <p>I am looking to do a left join on a table that has an array column called tags with a table that has the definitions of the tag, tag_definitions. There will only be one (at the most) match per row in the Cities Table. I can't join an array with a string and i'm not sure how to proceed.</p>
  <p>Cities_Table</p>
  <blockquote>
  <p>City_Code  | State   |Tags</p>
  <p>NYC | NY | 1, 4, 5</p>
  <p>SF | CA | 2,4, 6</p>
  <p>CHI | IL | 3, 8, 10</p>
  </blockquote>
  <p>.</p>
  <p>Tag_Definitions</p>
  <blockquote>
  <p>Tag_ID | Name</p>
  <p>5 | East_Coast</p>
  <p>6 | West_Coast</p>
  <p>10 | MidWest</p>
  </blockquote>
  <p>So I'm looking to get something like this...</p>
  <blockquote>
  <p>City_Code  | State   |Tags | Tag_Descr</p>
  <p>NYC | NY | 1, 4, 5 | East_Coast</p>
  <p>SF | CA | 2,4, 6 | West_Coast</p>
  <p>CHI | IL | 3, 8, 10 | MidWest</p>
  </blockquote>