Two tables SQL Table A minus Table B

 select a.id, a.revision, a.casetype

from A a
where not exists (
    select 1
    from B
    where revision = a.revision and casetype = a.casetype
);