Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE a (id) AS
SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= 5;
5 rows affected

CREATE TABLE b(id, type) AS
SELECT 1, 'type1' FROM DUAL UNION ALL
SELECT 1, 'type1' FROM DUAL UNION ALL
SELECT 2, 'type1' FROM DUAL UNION ALL
SELECT 2, 'type2' FROM DUAL UNION ALL
SELECT 3, 'type3' FROM DUAL UNION ALL
SELECT 4, 'type1' FROM DUAL UNION ALL
SELECT 5, 'type1' FROM DUAL UNION ALL
SELECT 5, 'type2' FROM DUAL;
8 rows affected

SELECT a.id,
       b1.type
FROM   a
       LEFT OUTER JOIN b b1
                    ON a.id = b1.id
                       AND b1.type = 'type1'
MINUS all
SELECT a.id,
       'type1'
FROM   a
       INNER JOIN b b1
               ON a.id = b1.id
                  AND b1.type = 'type2' 


ID
TYPE


1
type1

1
type1

4
type1

3
null