If it done not be done in in a single select, it is no good for my application.

Thanks for the help.