Question

I have following tables;

 A   B                       A   B
 _____                       _____
 1   t                       7   a
 2   r                       5   d
 3   e                       3   e
 4   f
 5   d
 6   s
 7   a

产出应为:

In other words I want difference of these two tables . I want region A in this figure. How can I do that ?

Answer 1

为此:

SELECT t1.*
FROM t1
LEFT JOIN t2 USING (A, B)
WHERE t2.A IS NULL

Answer 2

未使用<条码>。

SELECT A, B
FROM tableA
WHERE A NOT IN
    (SELECT Distinct A FROM tableB)

Answer 3

这应当做到:

SELECT 
    A, 
    B 
FROM Table_1
WHERE NOT EXISTS 
    (
        SELECT Table_2.A AS Test
        FROM Table_2 
        INNER JOIN Table_1 AS T ON Table_2.A = Table_1.A
    )

Answer 4

SELECT A, B 
  FROM Table1
EXCEPT
SELECT A, B 
  FROM Table2;

友情链接