distinct with union all

[Rakesh Setty]

Hi,

I have a query like

select distinct username from (select user as username from page_views pv union 
all select name as username from users u) ur;

But I see that result is not actually distinct. Am I missing something here?

Thanks,
Rakesh