I have 2 files, F1 and F2. These files have a common key field KEY. I need to produce SQL that will result in one file that has all of 1)Records whose KEY value is the same in both F1 and F2 2)Records with a KEY value in F1 and no corresponding KEY value in F2, and 3)Records with a KEY value in F2 and no corresponding KEY value in F1. I thought this might be simple to do with the following FROM clause: FROM F1 INNER JOIN F2 ON F2.KEY = F1.KEY LEFT EXCEPTION JOIN F2 ON F2.KEY = F1.KEY RIGHT EXCEPTION JOIN F2 ON F2.KEY = F1.KEY but as you experienced sql'ers out there know, when I run RUNSQLSTM to compile this file, I receive error "SQL0212 30 41 Position 21 Duplicate table designator F2 not valid." Does anyone have any suggestions? Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!