I have a table that has a column of partids. They are seperated with
commas. I need to select the partids from certain columns and use
them to select from another table. They are the ids for the subjects
table. If I grab the ids from the table then do another query using
them in a where id in clause it works fine. But I can't use a
subquery like where id in (select partids from collections where id =
346). It only uses the first number in the partids and that is it.
Is there a way around having to do 2 queries.