select id,typeid,controlid from A
union
select id,typeid,controlid from B假如数据为:
id type controlid
1 t1 c1
2 t1 c3
5 t2 c6
1 t1 c1
9 t2 c6要求把type和controlid相同行去掉``没有有主键ID(就是2个表ID可能重复)
有办法做到吗?```
union
select id,typeid,controlid from B假如数据为:
id type controlid
1 t1 c1
2 t1 c3
5 t2 c6
1 t1 c1
9 t2 c6要求把type和controlid相同行去掉``没有有主键ID(就是2个表ID可能重复)
有办法做到吗?```
等待大虾回答!!
(
select id,typeid,controlid from A
union all
select id,typeid,controlid from B
) t
group by typeid,controlid
我试过,你可以放心
--union 是去掉所有列都重复的行select max(id) id ,typeid,controlid from
(
select id,typeid,controlid from A
union all
select id,typeid,controlid from B
) t
group by typeid,controlid
--union 是去掉所有列都重复的行
能不能麻烦你举个例子啊