第一部分:
SELECT A.*
FROM A,
(SELECT jcode, MAX(wdate) AS wdate
FROM A
GROUP BY jcode) B
WHERE A.jcode= B.jcode
AND A.wdate= B.wdate第二部分:
select a.*,b.JCode,b.FundName from BM_FCombWinTbl a inner join BM_FCombDetailTbl b
on a.DetailId=b.DetailId
where b.CombId in(select CombId from BM_FundCombTbl
where CombType=101201 and UserId=888)请问:如何把第一部分的表A用第二部分的语句来代替?
我写成下面这样提示“对象名 't' 无效。”
select t.* from
(
select a.*,b.JCode,b.FundName from BM_FCombWinTbl a inner join BM_FCombDetailTbl b
on a.DetailId=b.DetailId
where b.CombId in(select CombId from BM_FundCombTbl
where CombType=101201 and UserId=888)
) t,(select jcode,max(wdate) as wdate from t group by jcode) b where t.jcode=b.jcode and t.wdate=b.wdate
SELECT A.*
FROM A,
(SELECT jcode, MAX(wdate) AS wdate
FROM A
GROUP BY jcode) B
WHERE A.jcode= B.jcode
AND A.wdate= B.wdate第二部分:
select a.*,b.JCode,b.FundName from BM_FCombWinTbl a inner join BM_FCombDetailTbl b
on a.DetailId=b.DetailId
where b.CombId in(select CombId from BM_FundCombTbl
where CombType=101201 and UserId=888)请问:如何把第一部分的表A用第二部分的语句来代替?
我写成下面这样提示“对象名 't' 无效。”
select t.* from
(
select a.*,b.JCode,b.FundName from BM_FCombWinTbl a inner join BM_FCombDetailTbl b
on a.DetailId=b.DetailId
where b.CombId in(select CombId from BM_FundCombTbl
where CombType=101201 and UserId=888)
) t,(select jcode,max(wdate) as wdate from t group by jcode) b where t.jcode=b.jcode and t.wdate=b.wdate
解决方案 »
- 求助!如何实现textbox之间的值修改互相绑定?
- .NET 怎样将一段前台代码封装成类供各页面调用
- 这样的功能要用什么控件实现比较好?Repeater?GridView?
- 如何让xp2装上IE6?请高手帮下
- 三层架构中,数据层与数据库通信中传输的数据量 相关
- Gridview效率最低,那么Datalist和Repeater谁的效率高?
- 如何将May 12th, 2013转成2013-05-12 这样的时间格式?
- 如何去除多余的字符串?????????
- 如何打包.net framework?(在线等,急)
- 200分!!关于web的无状态性的讨论~有见解的讨论有分!!
- 传参 出了问题?
- 这是不是.net的bug地址栏获取地址的问题
SELECT A.*
FROM (select a.*, b.JCode, b.FundName
from BM_FCombWinTbl a
inner join BM_FCombDetailTbl b on a.DetailId = b.DetailId
where b.CombId in (select CombId
from BM_FundCombTbl
where CombType = 101201
and UserId = 888)) A,
(SELECT jcode, MAX(wdate) AS wdate
FROM (select a.*, b.JCode, b.FundName
from BM_FCombWinTbl a
inner join BM_FCombDetailTbl b on a.DetailId = b.DetailId
where b.CombId in (select CombId
from BM_FundCombTbl
where CombType = 101201
and UserId = 888)) A
GROUP BY jcode) B
WHERE A.jcode = B.jcode
AND A.wdate = B.wdate
SELECT AA.*
FROM (SELECT A.*, B.JCODE, B.FUNDNAME
FROM BM_FCOMBWINTBL A, BM_FCOMBDETAILTBL B, BM_FUNDCOMBTBL C
WHERE A.DETAILID = B.DETAILID
AND B.COMBID = C.COMBID
AND C.COMBTYPE = 101201
AND C.USERID = 888) AA,
(SELECT JCODE, MAX(WDATE) AS WDATE FROM T GROUP BY JCODE) BB
WHERE AA.JCODE = BB.JCODE
AND AA.WDATE = BB.WDATE
SET NOCOUNT ONselect a.*,b.JCode,b.FundName into #temp from BM_FCombWinTbl a inner join BM_FCombDetailTbl b
on a.DetailId=b.DetailId
where b.CombId in(select CombId from BM_FundCombTbl
where CombType=101201 and UserId=888) SELECT #temp.*
FROM #temp,
(SELECT jcode, MAX(wdate) AS wdate
FROM #temp
GROUP BY jcode) B
WHERE #temp.jcode= B.jcode
AND #temp.wdate= B.wdateEND GO