For those of you with a slight interest in WQL queries for your ConfigMgr collections ...
Jeroen Erkelens writes up a good introductory guide to sub-select statements in WQL queries
Read the complete post at http://wmug.co.uk/blogs/r0b/archive/2009/12/30/wql-sub-select-queries.aspx