mysql中union的替换,Mysql中UNION子句的替代

I have two table :- table a, table b.

table a

---ID---

1

2

3

4

5

7

table b

---ID----

2

3

4

5

6

I have to get Output Like this without UNION Command:-

----ID-----

1

2

3

4

5

6

7

Note: I have one solution with union:-

**select * from a

UNION

select * from b;**

I need alternative to this. please experts suggest.

解决方案

We need another table with (at least) 2 rows for this:

CREATE TABLE d

( id INT NOT NULL

);

INSERT INTO d

(id)

VALUES

(0), (1) ;

Then, if we want to have only one query, we can use (this is for fun, DO NOT USE in production, that's why we have UNION):

SELECT DISTINCT

COALESCE(aa.id, bb.id) AS id

FROM

d

LEFT JOIN a AS aa ON d.id = 0

LEFT JOIN b AS bb ON d.id = 1

WHERE

COALESCE(aa.id, bb.id) IS NOT NULL

ORDER BY

id ;

Tested at