SELECT COUNT(a.*) As iNumber
From SwyMaster a, SwyMaster b
WHERE a.flag1 = 's'
AND LEFT(a.treecode, LEN(b.code)) = b.code
AND LEFT(a.ym,6) = '200409'
AND CHARINDEX('g', a.treecode, LEN(b.code) + 1) = 0
AND b.flag1 = 'g'
AND b.topcode = '7080'
AND LEFT(b.ym, 6) <= '200409'
From SwyMaster a, SwyMaster b
WHERE a.flag1 = 's'
AND LEFT(a.treecode, LEN(b.code)) = b.code
AND LEFT(a.ym,6) = '200409'
AND CHARINDEX('g', a.treecode, LEN(b.code) + 1) = 0
AND b.flag1 = 'g'
AND b.topcode = '7080'
AND LEFT(b.ym, 6) <= '200409'
解决方案 »
- delete语句支持多表删除么?
- 关于连接后索引失效问题求高手解答
- sql2000如何不显示指定列
- 难道这就是传说中分布式数据处理
- 数据库有没有移动(备份)mdf文件的命令?或者用DOS命令实现?
- Sql server2000打了sp3补丁后,打补丁sp4后依然显示版本信息sp3,为何?
- 选择一个表的字段时,就不想选某个字段,有没有方法可以实现啊?>
- SQL2000 函数返回多值并调用问题
- 一個組數的問題
- ORACLE的DATE类型既包括日期又包括时间吗?ORACLE还有其它时间类型吗?在DELPHI中怎样把当前日期时间存到DATE类型字段中?
- 在线等,有关存储过程用视图影响查询效率的问题
- 如果邮件服务器不在局域网,而是在某一固定IP上,怎么来配置sqlmail?
FROM SwyMaster
WHERE (flag1 = 's')
AND (LEFT(treecode, LEN(aa.treecode)) = aa.treecode)
AND (LEFT(ym, 6) = '200409')
AND (CHARINDEX('g', treecode, LEN(aa.treecode) + 1) = 0)
)
FROM SwyMaster aa
WHERE (aa.flag1 = 'g')
AND (aa.topcode = '7080')
AND (LEFT(aa.ym, 6) <= '200409')