回答編集履歴
1
調整
test
CHANGED
@@ -2,3 +2,20 @@
|
|
2
2
|
例示のクエリーをサブクエリーにして
|
3
3
|
「select 777 as card_no union all select 888 union all select 999」を
|
4
4
|
right joinする手はあります。
|
5
|
+
|
6
|
+
```SQL
|
7
|
+
create table tbl(id int primary key,card_no int,val varchar(10),unique key(card_no));
|
8
|
+
insert into tbl values
|
9
|
+
(1,555,'aaa'),
|
10
|
+
(2,666,'bbb'),
|
11
|
+
(3,777,'ccc'),
|
12
|
+
(4,999,'ddd');
|
13
|
+
```
|
14
|
+
これに対してこんな感じ
|
15
|
+
```SQL
|
16
|
+
select * from
|
17
|
+
(select * from tbl where card_no in (777,888,999)) as t1
|
18
|
+
right join
|
19
|
+
(select 777 as card_no union all select 888 union all select 999) as t2
|
20
|
+
using (card_no)
|
21
|
+
````
|