Dealing with Duplicate When Joining (Left Join) 3 Tables ( With many columns as PK)

Question

Hello Everyone,

I have a problem with duplicate records when joining my tables
Table 1 ( P_ID and G_ID as Primary Key)
Table 2  ( P_ID as Primary Key )
Table 3 ( P_ID and G_ID and F_ID as Primary Key )

I did my table joining as :

Join 1 : Table 1 and Table 2 ON table1.P_ID = table2.P_ID
Join 2 : Result of Join 1 and Table 3 ON ResultJoin1.P_ID = table3.P_ID AND ResultJoin1.G_ID = table3.G_ID

The final table has duplicate records , i know it's normal cause my tables don't have the same columns as Primary Key

Can you guide me to avoid these duplicate records please ?

Thanks

simonaubert_bd · Answer

Hello @Christopher_ZK

If you use In db tools, you must use a summarize in db in order to aggregate your data and avoid duplicate.

Best regards,

Simon

Christopher_ZK · Answer

Thanks ,

I will do it and i will come back

Kind regards

Felipe_Ribeir0 · Answer

Hi @Christopher_ZK

Dont worry about the specific order of the print, it was only an example (as i dont know exactly how your data looks like). Just adapt the idea of removing duplicates based on the key columns using the unique tool before of the join for the necessary tables and i think that it gonna work.