select max(单据日期) from (select 单据日期 from 表1 union select 单据日期 from 表2 union select 单据日期 from 表3)
select max(t1.FDate) from (select FDate = max(FDate) from jxcxiaohdM union select FDate =max(FDate) from JxcJinhdM union select FDate =Max(FDate) from JxcJiecdM) as t1
select max(单据日期),Min(单据日期) from (select 单据日期 from 表1 union select 单据日期 from 表2 union select 单据日期 from 表3)
select max([Year]) from (select [Year] from Sum_Lost union select [Year] from Sum_Register) as db 我测试过了,绝对ok
各位老兄: 汇报一下试验结果: SELECT MIN(单据日期) AS A,MAX(单据日期) AS B FROM ( SELECT 单据日期 FROM LHA_CRECEIVED UNION SELECT 单据日期 FROM LHA_PRETURN ) AS DB 可以,但是不明白为什么要加最后那个AS DB ,不加这个会出错? 那个AS DB的DB是什么类型?是列名吗?还是结果集? 再次感谢!
union select 单据日期 from 表3)
(select FDate = max(FDate) from jxcxiaohdM
union
select FDate =max(FDate) from JxcJinhdM
union
select FDate =Max(FDate) from JxcJiecdM) as t1
union select 单据日期 from 表3)
我测试过了,绝对ok
汇报一下试验结果:
SELECT MIN(单据日期) AS A,MAX(单据日期) AS B FROM ( SELECT 单据日期 FROM LHA_CRECEIVED
UNION SELECT 单据日期 FROM LHA_PRETURN ) AS DB
可以,但是不明白为什么要加最后那个AS DB ,不加这个会出错? 那个AS DB的DB是什么类型?是列名吗?还是结果集?
再次感谢!