SQL Query : How to to Purchase Invoice to Purchase Order

1

Hi,

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.

2

@Kartive_Can you please explain your case with images?