SQL Query : How to to Purchase Invoice to Purchase Order


Can anyone please advise how to link( the table and fields) the Purchase Order table with the Purchase Invoice?

I have tried Purchase Order to Purchase Receipt but when adding the Purchase Order Item table table the values are duplicating.

Best regards,


@Kartive_Can you please explain your case with images?