You could try something like this.
The Subselect picks the list that you don’t want so you use the NOT IN (the list)
SELECT A.DEAL5, A.RO5, A.LINE5, A.RODTE5 FROM NCLM5 A
where A.Visit5 = ‘H’ and A.R05 not in
(select A.R05 from NCLM5 where visit5 = ‘ ‘)
I believe that this is the same SQL command that you would use in any other database.