使用连接条件写查询

Question

有两个表table1,table2

table1:

我想这会达到你的目的。

SELECT table1.number
,table1.type
,table1.name
,table2.name
FROM table1
JOIN table2 ON 
table2.number = table1.number AND
table2.type = table1.type AND
table1.name NOT IN (SELECT t2.name 
FROM table2 t2 
WHERE t2.number = table1.number AND 
t2.type = table1.type)