Hi Jack
I'm not sure if I understand your comment about two 'Ted' fields and
duplication of rows. In the example below there is 'Ted' twice in Table3 1
and 3 and must appear twice as I've shown in the result as the data in the
rest of the row is different. I agree with no duplication of rows if all of
the row is the same.
Ted
Table: 1
Author Title Sales Publication Date
Jim A aa I
Ted B bb J
Dave C cc K
Ted D dd L
Table: 2
Author Publisher
Jim him
Ted me
Dave me
Will you
Gary him
Table:3
Author Title Country
Ted B UK
Ted D US
Jim A UK
Dave C UK
Combined table: Result
Author Title Publication Date Publisher Sales Country
Ted B J me bb UK
Ted D L me dd US
Jim A I him aa UK
Dave C K me cc UK
Gary null null him null null
Will null null you null null
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html