Hi I am having som problems with a simple query

SELECT *
FROM Contact 
WHERE id IN (
	SELECT contactlist FROM customer WHERE id = 123
)

This works if the contactlist only returns 1 id. But if it returns a list like

"123, 456, 789"

The the

IN

statement will not work. if i could convert the comma separated list to rows I guess this should work

Why not use Contact’s company field directly for the filter?

SELECT *
FROM Contact
WHERE Contact.company = 123

Oi. I am sure I searched for that and did not find it 😄 Thanks, that makes this a lot easier 👍