join table with multiple field entrys?

[Thundarfoot]

I am a noob hre is my sign:  ???

I am trying to join 2 tables. a value from table a matches an id from table b..

this code works however some fields in table a contain multiple values when this happens only the first is returned.

SELECT * FROM tablea LEFT OUTER JOIN tableb ON (tablea.column2 = tableb.id)";

 

sample table a

Column1 | Column2 |

firstentry  10

secondentry 20 30 12

thirdentry 05

 

above code returns joined entrys from table b for id 10, 20, and 05 but not 30 or 12

 

I can modify column 2 or its contents if needed to make this work.

Thank you in advance for your time and any help you can lend.