Quoting Henry Ortega <juandelacruz(at)gmail(dot)com>:
> Is it possible at all to do this without any joins> or subselect?
Nope. But I'm curious why you make that a condition?