SELECT
t1.a
, t1.b
, t1.c
, t2.nm
FROM
t1
LEFT JOIN
t2
ON t1.id = t2.aid
WHERE
t1.id is null OR SUBSTR(t1.b,4) != t2.nm
08-16
SELECT
t1.a
, t1.b
, t1.c
, t2.nm
FROM
t1
LEFT JOIN
t2
ON t1.id = t2.aid
WHERE
t1.id is null OR SUBSTR(t1.b,4) != t2.nm