Home
Forums
New posts
What's new
New posts
New profile posts
Latest activity
Advertise
Members
Current visitors
New profile posts
Resources
Log in
Register
What's new
New posts
Menu
Log in
Register
Install the app
Install
Home
Forums
JD Edwards® World™ Discussions
JD Edwards® World™
F0911 LEFT JOIN F0411
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="iaw1978" data-source="post: 199876" data-attributes="member: 53726"><p>Hi,</p><p></p><p>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:</p><p></p><p>1) F0911 - what's the difference between GLKCO and GLCO?</p><p></p><p>F0911</p><p> LEFT JOIN</p><p>F0411</p><p> ON F0911.GLKCO = F0411.RPKCO AND</p><p> F0911.GLDCT = F0411.RPDCT AND</p><p> F0911.GLDOC = F0411.RPDOC </p><p></p><p>Is this right?</p><p></p><p>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?</p></blockquote><p></p>
[QUOTE="iaw1978, post: 199876, member: 53726"] 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? [/QUOTE]
Verification
Post reply
Home
Forums
JD Edwards® World™ Discussions
JD Edwards® World™
F0911 LEFT JOIN F0411
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top
