Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

left outer join`

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • left outer join`

    FROM FILEA LEFT OUTER JOIN FILEB on ItemA = ItemB LEFT OUTER JOIN FILEC on ItemA = ItemC

  • #2
    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

    Comment


    • #3
      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

      Working...
      X