I can't think of any way to do it in SQL without using sub queries which is obviously not an option in NS