Focal Point
another question on the records that are not included from the JOIN

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9591087331

July 12, 2004, 06:32 PM
serenekk
another question on the records that are not included from the JOIN
I have 2 tables. 1sthold is the hold file of the first and 2ndhold is the second hold file of the second table. 1sthold resulted, say,1400 s.s# numbers and 2ndhold has 700 s.s#. I join from 1sthold to 2ndhold by ss# to get all the other fields, but not all the 700 ss# are included in the result. how do I get them all those 700 added in the join?
July 12, 2004, 08:07 PM
GCohen
The MATCH command is designed to provide the various types of file 'matches'. For example..
MATCH FILE ONE
SUM A AND B BY SSN
WHERE SOMETHING ;
RUN
FILE TWO
SUM D AND E BY SSN
WHERE SOMETHING ;
ON MATCH HOLD OLD-NOT-NEW
END
-* OTHER CHOICES ARE OLD-AND-NEW, OLD-NOR-NEW
-* OLD-OR-NEW, ETC...
TABLE FILE HOLD
get the desired report..
end
July 15, 2004, 09:25 PM
Bob Jude Ferrante
the setting ALL (SET ALL=ON) would make sure the left-hand rows would be included regardless of if they had matches... you don't need to use the complex MATCH command if this is all you want.