Just re-read your question. the above won't do what you asked...

I'd need to have a think whether a single SQL statement will do it.