JeffWilson
Member
OK...this sounds simple, but I can't seem to get it. I am trying to do a
Query/400 or Query manager quesry to get ALL items from the F4101 and the
costs for each only if they exist and only if they are Ledger Type 07. So I
want Item 12345 with a it's "07" cost or with NO cost if there is no "07"cost
in F4105. Since I am selecting based on the COLEDG field, I am not getting
the records that are not in that file. Can someone point me in the right
direction on this? Thanks very much in advance for any help you can give.
Jeff Wilson
Director of IT - Manufacturing
Unilever Cosmetics International
Query/400 or Query manager quesry to get ALL items from the F4101 and the
costs for each only if they exist and only if they are Ledger Type 07. So I
want Item 12345 with a it's "07" cost or with NO cost if there is no "07"cost
in F4105. Since I am selecting based on the COLEDG field, I am not getting
the records that are not in that file. Can someone point me in the right
direction on this? Thanks very much in advance for any help you can give.
Jeff Wilson
Director of IT - Manufacturing
Unilever Cosmetics International