Yes, with two sql statemetns
If you change the join RDB.CARF1.INMSP100 INMSP100 join RDB.CARF1.MSPMP100 MSPMP100
to RDB.CARF1.INMSP100 INMSP100 LEFT join RDB.CARF1.MSPMP100 MSPMP100
it will show every record from the field on the left RDB.CARF1.INMSP100 INMSP100
even those that aren’t matched on the right but you want to eliminate those with a match on the righ
so at the end of the sql add
where MSPMP100.CLASS is NULL
That will give you INMSP100′s that aren’t matched
For the others you will need to reverse the process
RDB.CARF1.INMSP100 INMSP100 RIGHT join RDB.CARF1.MSPMP100 MSPMP100
where INMSP100.MSCLS is NULL
Littlepd asked a good question.
You can run this statement on the 400 – in a session use STRSQL
or using Navigator select SQL
either option would be faster.
Not familiar with “pass-though” in Access — it’s been awhile since I’ve used access (hit computers were made of rocks and had cranks). The pass-through should do just fine. Data Transfer System i is used for coping data from the AS/400 (system i) to your pc. So did the querys with Left and Right join work?