select name from 表A union select name from 表B这个的where语句怎么写?
select name from 表A union select name from 表B这个的where语句怎么写? ------------------------------如果要加上条件可以这样 select name from 表A where --- union select name from 表B where --- 或者 select * from (select name from 表A union select name from 表B)a where --
没听明白啊?
是取重复的还是取不重复的?
弄个例子
union
select name from 表B
union
select name from 表B这个的where语句怎么写?
union
select name from 表B这个的where语句怎么写?
------------------------------如果要加上条件可以这样
select name from 表A where ---
union
select name from 表B where ---
或者
select * from
(select name from 表A
union
select name from 表B)a
where --