Re: joining tables

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