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.
January 20, 2005 2:11 PM
January 23, 2005 1:34 AM