B2B Query

Hi Experts

I need a query to show me the status of rows from back to back Purchase Orders / Sales Orders. I need to be able to query it by the Sales Employee name in the Sales Order as a user input, I can see that there is a Target PO ref on the Sales Order RDR1 table but I can't figure out how to link it to the POR1 table because my SQL isnt so good!

What I would ultimately like to see is:

Supplier name

Supplier reference number

PO Number

SO Number

Item Code

Item Description

Qty

Sales Employee Name (from SO)

Delivery date (from PO)

kinds regards

Geoff