select distinct name from a
union
select distinct name from b
---------
感觉没有必要用distinct
union all 时用distinct,如果是union就会自动去除重复值。
明白楼主的意思,
from TS_CX_HJ a FULL OUTER JOIN tt_jkrecord b on a.poJID=b.poJID and a.chDay=b.stDay
where a.poJID='3' and DATEPART(yyyy,a.chDay)='2003' and DATEPART(mm,a.chDay)='7' and DATEPART(dd,a.chDay)='07'
这段话比较浪费的意思,能不能合并处理。
---
如果就是这样合并两个字段这样就可以了,如果是还有c.poID等其他字段,那就可以写个函数之类的,用动态sql执行就可以。
我这样干了,也行,但是太死板了。
(select Distinct a.poID from TS_CX_HJ a FULL OUTER JOIN tt_jkrecord b on a.poJID=b.poJID and a.chDay=b.stDay
where a.poJID='3' and DATEPART(yyyy,a.chDay)='2003' and DATEPART(mm,a.chDay)='7' and DATEPART(dd,a.chDay)='07')
union
(select Distinct b.poID from TS_CX_HJ a FULL OUTER JOIN tt_jkrecord b on a.poJID=b.poJID and a.chDay=b.stDay
where a.poJID='3' and DATEPART(yyyy,a.chDay)='2003' and DATEPART(mm,a.chDay)='7' and DATEPART(dd,a.chDay)='07')
各位老兄:其实这两个表要经过全连接:看看这个sql如何改,可以合并:a.poID ,b.poID 为一个字段?
select Distinct a.poID ,b.poID from TS_CX_HJ a FULL OUTER JOIN tt_jkrecord b on a.poJID=b.poJID and a.chDay=b.stDay
where a.poJID='3' and DATEPART(yyyy,a.chDay)='2003' and DATEPART(mm,a.chDay)='7' and DATEPART(dd,a.chDay)='07'