Well it works with oracle (I just tried it again to be sure). Of course as you mentioned it is only going to return one row and I am not sure how it determines which row to return. Distinct does the same thing FWIW.

-Mike

_________________________
EmpMenuX - ext3 filesystem - Empeg iTunes integration