select a.编号,a.日期,a.备注+b.备注 from 表名 as a,表名 as b where a.编号=b.编号 and a.日期=b.日期 union all select a.编号,a.日期,a.备注 from 表名 as a,表名 as b where (a.编号<>b.编号 or a.日期<>b.日期)
谢谢,没关系不一定只要一条,BBBBAAAAA也是可以的。
谢谢,不能用Union 操作,因为这条语句还要用来连接。
select a.编号,a.日期,a.备注+b.备注 from table1 as a inner join table1 as b on a.编号=b.编号 and a.日期=b.日期 and a.备注<>b.备注
from 表名 as a,表名 as b
where a.编号=b.编号 and a.日期=b.日期
union all
select a.编号,a.日期,a.备注
from 表名 as a,表名 as b
where (a.编号<>b.编号 or a.日期<>b.日期)