Harry,

If I understand you correctly, you want to find any records in BALANCE that do not have matching TYPEs in PTYPES.

SELECT * FROM balance ;
WHERE type NOT IN (SELECT type FROM ptypes)

>Every TYPE in BALANCE should have a match in PTYPES.
>
>I deliberately alter a TYPE in BALANCE to ensure that at least one record does not have a match.