G. J. Walsh wrote:
> 1 of the 4 tables has the complete range of keys, in this case about
> 1,000. The other 3 tables have data representing most but not all of
> those keys, and in different sets. I want to end up with a new
> 'combined' table which will allow me to immediately 'see' missing data
> from the 3 smaller tables and take the necessary steps to 'fill in the
> blanks'. I realize I would of course have to create that table without
> constrictions other than the primary key.
Do you mean you want to find keys that exist in the 'main' table but
have no match in the other three tables?
In response to
pgsql-novice by date
|Next:||From: G. J. Walsh||Date: 2008-10-26 05:26:56|
|Subject: Re: combining tables|
|Previous:||From: G. J. Walsh||Date: 2008-10-26 01:02:39|
|Subject: combining tables|