Why are you so sure? Do you have a case for it? I never could get a faster program using 2 SELECTs when I could use one embeded into other. This goes for cases similar to the one discussed here. It's true that for other cases you may have a better performance if you can separate.

Vlad

>Hi Robert!
>
>I'm sure that the separate simple queries is faster than one sophisticated.
>As I can assume, Rushmore optimization work just fine on
>simple query but when you have nested selects with unions etc it might fail
>down.
>
>* Will write login scripts for food
>
>>I don't know about the speed of nested selects vs. seperate selects.
>>But as you said I think the single statment would be faster.