>>Not sure.
>>I was just curious if that will works.
>>I never used WHERE xxx IN (SELECT ....) in my queries. I prefer to use JOINS and derived tables.
>>They are fatser (In my opinion, never made proper tests though).
>
>Yes, they are almost every time faster than subqueries.

thats good to know, I'll try to think of possible ways to do things via joins in future, subqueries just generally read more easily to me, hence that being the first way I wrote it.