Josh Williams wrote:
> On Thu, 2008-10-09 at 10:59 -0600, Bill Thoen wrote:
>
>>>> I'm trying to combine two tables, but I only want unique records based
>>>> on the first two columns. Can UNION be used to join three-column tables
>>>> but only include records based on the uniqueness of the first two
>>>> columns? If not, how would I do this with PostgreSQL 8.1?
>>>>
>>> How do you decide which records you want? - e.g. given the following rows...
>>>
>>> (a, b, c)
>>> (a, b, d)
>>>
>>> ...how do you decide whether you the one with c or the one with d?
>>>
>>>
>>>
>> The physical order that they appear will take care of that.
>>
>
> If the rest of the columns don't matter, how about:
>
> SELECT DISTINCT ON(col1, col2) * FROM (
> SELECT col1, col2, col3 FROM table1
> UNION
> SELECT col1, col2, col3 FROM table2
> ORDER BY col1, col2
> ) AS uniontable;
>
> - Josh Williams
>
Great! This works too.
And to correct my last post, David Wilson had it right the SECOND time.
I've been wrestling with this stupid problem all morning and now my mind
is so gone I don't even trust whether I can get 'SELECT * FROM table1;'
to work!
Thanks for the help once again everybody!!!
