"hjenkins" <[EMAIL PROTECTED]> writes:
> So I tried:
> UPDATE schema1.datatable SET schema1.datatable.field1 =
> schema2.datatable.field1 FROM schema2.datatable
> WHERE schema2.datatable.keyfield = schema1.datatable.keyfield
> AND schema1.datatable.field1 = None;
> Which is suboptimal because I'd
Hello,
I have a table of rows which partially duplicate one another and need to
be merged and moved into a table with a primary key.
As an additional complication, some of the duplicates contain different
information, ex.:
schema1.datatable: key1 None None 34
schema2.datatable: key1 12
