title: SQL - Using a join on a column with multiple values in cells
body: <p>I have two tables I am trying to join. One table has a column with IDs in it, and I am trying to do a left join to a different table that has the same IDs in it, although the second table could contain more than one ID per cell. For example, if my first table has an ID value of <code>123</code>, and the second table has an ID value of <code>123;724;823</code>, is there any way to get it to join the two rows? </p>