Re: tubles matching

On 28 September 2011 13:19, salah jubeh <s_jubeh(at)yahoo(dot)com> wrote:
>
> Hello,
>
> I have two views both contain  identical column names , order and types
> except the primary keys. I want to match these two views - return the pk
> pair  of the rows which match from these views - by comparing all the column
> values. I want to write a pgplsql function to do this Job by iterating
> through all the coloumns and compare the values.
>
> Is there another way to do that ?

SELECT a.pk1, a.pk2 FROM view1 AS b INNER JOIN view2 AS b ON (a.pk1 =
b.pk1 AND a.pk2 = b.pk2 AND a.col1 = b.col1 AND a.col2=b.col2);

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.