Yes, I am getting duplicate usernames.
________________________________ From: Namit Jain [mailto:[email protected]] Sent: Thursday, July 02, 2009 1:25 PM To: [email protected] Subject: RE: distinct with union all Are you getting duplicate usernames ? From: Rakesh Setty [mailto:[email protected]] Sent: Thursday, July 02, 2009 12:37 PM To: [email protected] Subject: distinct with union all 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
