FROM FILEA LEFT OUTER JOIN FILEB on ItemA = ItemB LEFT OUTER JOIN FILEC on ItemA = ItemC
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
left outer join`
Collapse
X
-
left outer join`
I need to have 3 files joined. I would like to have all records in fileA plus any matching records in fileB and FileC. The on needs to be different between FILEA and FILEB and FILEA and FILEC. Any suggestions? Can it be done? I think maybe something like this: FROM FILEA LEFT OUTER JOIN FILEB on ItemA = ItemB --- Then I get lost. How do I get file C in so that it selects all of FILEA and the records from FileC that match with a different on condition? Thanks for any help Roger
-
left outer join`
I am still having problems with my join. I have attached the code and the error message. FROM F4211 INNER JOIN F4101 - on Sditm = Imitm - LEFT OUTER JOIN F5642103 - on Sddoco = Oddoco - and Sditm = Oditm - and Sdlnid = Odlnid - WHERE Sddoc = ? - and Sdmcu = ? - The error message states that the Token F4101 was not valid. Valid tokens: FOR WITH FETCH OPTIMIZE. Any suggestions would be appreciated. Thanks Roger
Comment
Comment