How do I link por1 and rdr1?

[Former Member]

Which if any is correct?

select opor.docnum, rdr1.PoTrgNum, rdr1.PoLineNum from opor

Left join por1 on por1.docentry = opor.docentry

Left join rdr1 on rdr1.PoTrgNum = por1.docentry

where opor.docnum = 5

select opor.docnum, rdr1.PoTrgNum, rdr1.PoLineNum from opor

Left join por1 on por1.docEntry = opor.docEntry

Left join rdr1 on rdr1.docEntry = por1.BaseRef

where opor.docnum = 5

[former_member201110 · Accepted solution]

Hi Charles,

The short answer is neither

Try something like this:

select 
	T0.DocNum as [PO Number], 
	T1.LineNum as [PO Line],
	T3.DocNum as [SO Number], 
	T2.LineNum as [SO Line] 
from 
	OPOR T0
	inner join POR1 T1 on T1.DocEntry = T0.DocEntry
	left outer join RDR1 T2 on T2.DocEntry = T1.BaseEntry and T2.LineNum = T1.BaseLine and T1.BaseType = 17
	left outer join ORDR T3 on T2.DocEntry = T3.DocEntry
where
	T0.DocNum = 5

Kind Regards,

Owen