如 A表:ORDERID ID KIND 1 1 a 2 2 b B表:ORDERID ID KIND 1 2 C 结果表,以ORDERID为条件:1 ORDERID ID KIND 1 1 a 1 2 c 该怎么写呀
select * from ( select 订单号,编号,名称,型号 from 衣服信息 UNION select 订单号,编号,名称,型号 from 裤子信息 )as info where info.订单号="";
select * from (select orderid,id,kind from A union all select orderid,id,kind from B ) where orderid = 1
select * from ( select orderid,id,kind from table A UNION select orderid,id,kind from table B )as C where C.orderid=1
create or replace view ABC as select ORDERID,ID,KIND from( select ORDERID,ID,KIND from A where ORDERID=1 union all select ORDERID,ID,KIND from B where ORDERID=1 )
A表:ORDERID ID KIND
1 1 a
2 2 b
B表:ORDERID ID KIND
1 2 C
结果表,以ORDERID为条件:1
ORDERID ID KIND
1 1 a
1 2 c
该怎么写呀
select 订单号,编号,名称,型号 from 衣服信息
UNION
select 订单号,编号,名称,型号 from 裤子信息
)as info where info.订单号="";
(select orderid,id,kind from A
union all
select orderid,id,kind from B
)
where orderid = 1
select orderid,id,kind from table A
UNION
select orderid,id,kind from table B
)as C where C.orderid=1
select ORDERID,ID,KIND from(
select ORDERID,ID,KIND from A where ORDERID=1
union all
select ORDERID,ID,KIND from B where ORDERID=1
)