Question

我有以下表格:

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

产出应为:

In other words I want really different thing. I can only tell with this figure, take a look at. I want (A union B). How can I do that ?

Answer 1

这样做。它从两个表格中汇集了所有记录,然后显示了一度存在的所有记录。

SELECT
  A, B
FROM
  (SELECT A, B FROM TABLE1
   UNION ALL
   SELECT A, B FROM TABLE2)
  AS COMBINED
GROUP BY
  A, B
HAVING
    COUNT(*) = 1
ORDER BY A;

Answer 2

SELECT f.A, f.B
FROM firstTable f
LEFT JOIN secondTable s ON (f.A = s.A)
WHERE (s.A IS NULL)
UNION
SELECT s.A, s.B
FROM firstTable f
RIGHT JOIN secondTable s ON (f.A = s.A)
WHERE (f.A IS NULL)

Answer 3

SELECT iResult.* 
FROM
    (SELECT A, B
    FROM tableA
    WHERE A NOT IN
        (SELECT Distinct A FROM tableB)
    UNION
    SELECT A, B
    FROM tableB
    WHERE A NOT IN
        (SELECT Distinct A FROM tableB)) as iResult

Answer 4

SELECT A, B
FROM Table1

UNION

SELECT A, B
FROM Table2

EXCEPT

SELECT t1.A, t1.B
FROM Table1 t1
  INNER JOIN Table2 t2 ON t1.A = t2.A AND t1.B = t2.B

Answer 5

<><>Edit>/strong> 删除了先前的“溶解”一词,因为我认识到这与加里提出的解决办法相同。

(select a, b from table_1 minus 
 select a, b from table_2)       union
(select a, b from table_2 minus 
 select a, b from table_1);

这似乎与甲骨文的后续数据有关:

create table table_1 (
  a number,
  b varchar(2)
);

create table table_2 (
  a number,
  b varchar(2)
);


insert into table_1 values  (1  , t );
insert into table_1 values  (2  , r );
insert into table_1 values  (3  , e );
insert into table_1 values  (4  , f );
insert into table_1 values  (5  , d );
insert into table_1 values  (6  , s );
insert into table_1 values  (7  , a );

insert into table_2 values  (7  , a );
insert into table_2 values  (5  , d );
insert into table_2 values  (3  , e );
insert into table_2 values  (9  , a );
insert into table_2 values  (10 , c );
insert into table_2 values  (11 , a );

Answer 6

简单

SELECT a, b FROM table1 UNION SELECT a, b FROM table2;

友情链接