On Mon, 20 Dec 2004 14:52:35 -0500, Michael McMullen <ganstadba@xxxxxxxxxxx> wrote: > use an analytical [SNIP] Wouldn't that return just one row (no matter how many users there are). I read it as he wanted one row (any row) per user. Stephen -- //www.freelists.org/webpage/oracle-l