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