distinct in union
From: (wrong string) ł Jabłoński <michal.jablonsk_at_gmail.com>
Date: Wed, 6 Oct 2010 01:45:30 -0700 (PDT)
Message-ID: <dd72de04-5cbe-4668-8097-7f7d31b97542_at_l20g2000yqm.googlegroups.com>
The following query:
select a_id,b, c from table1
union all
select a2_id,b2,c2 from table2
Date: Wed, 6 Oct 2010 01:45:30 -0700 (PDT)
Message-ID: <dd72de04-5cbe-4668-8097-7f7d31b97542_at_l20g2000yqm.googlegroups.com>
The following query:
select a_id,b, c from table1
union all
select a2_id,b2,c2 from table2
gives me a result:
1,2,3
2,2,3
but I want only values from second table. What is the most efficient way to do that? Received on Wed Oct 06 2010 - 03:45:30 CDT