I still get a queries of this type are not supported error when using the IN clause for the sub-query.

(I created a couple of table to test the solution out).


>Nonsense. You can have them. But the correct syntax is WHERE something IN (subquery) not something = subquery as it appeared in the original question.
>
>That doesn't mean that a subquery is needed here.