Andrew2009
Well Known Member
Below is a join for my business view
F0901.AID Simple(==) = F0902.AID
F0901.MCU Simple(==) = F0006.MCU
Data selection is below. Only FY is set in the initialize section of the UBE. All others are set when users run the report
F0902.FY = 17
F0902.LT = JA or JU
F0006.MCU = 113246
F0006.PECC != N
I have records in F0901 that DO NOT exist in F0902 yet but I want to include these records in the result.
I tried both SQL 92 and regular left outer join as mentioned in the document (Doc ID 646081.1) but they both do not work.
Do you have any ideas?
Thanks
JDE 9.1
F0901.AID Simple(==) = F0902.AID
F0901.MCU Simple(==) = F0006.MCU
Data selection is below. Only FY is set in the initialize section of the UBE. All others are set when users run the report
F0902.FY = 17
F0902.LT = JA or JU
F0006.MCU = 113246
F0006.PECC != N
I have records in F0901 that DO NOT exist in F0902 yet but I want to include these records in the result.
I tried both SQL 92 and regular left outer join as mentioned in the document (Doc ID 646081.1) but they both do not work.
Do you have any ideas?
Thanks
JDE 9.1