A7.3 F0911 LEFT JOIN F0411

iaw1978

Member
Hi,

Using an extremely old version of JDE (7.2 maybe?) and trying to understand how to join a few tables and a few other questions ... trying to get the po/invoice number associated with each PV/OV in F0911 and for the most part understand the joins, but a few grey areas:

1) F0911 - what's the difference between GLKCO and GLCO?

F0911
LEFT JOIN
F0411
ON F0911.GLKCO = F0411.RPKCO AND
F0911.GLDCT = F0411.RPDCT AND
F0911.GLDOC = F0411.RPDOC

Is this right?

This would give me all for OV/PV that have no matching, then everything else would be a separate LEFT JOIN on F4311 to F43121 for OV/PV that have a PO?
 
Top