TRY:SELECT * FROM ( select yhh as A,jh AS B,SUM(hjdf) AS C from (select * from USER_HF_TEST.view_dlfx)AA where fxrq >= '1900-01-01' and fxrq <= '2003-3-25' and ( JH ='23' or JH ='26')group by yhh,JH ) T1 LEFT JOIN ( SELECT DLYH.YHH AS M,DLYH.JH AS N FROM T1,DLYH WHERE (DLYH.JH=T1.B AND DLYH.YHH=T1.A) )T2 ON (T1.A=T2.M AND T1.B=T2.N) WHERE (T2.M IS NULL AND T2.N IS NULL)
TO tj_dns(愉快的登山者) 错误提示的就是这不对,请问如何解决?
TO CrazyFor(蚂蚁) select yhh as A,jh AS B,SUM(hjdf) AS C from openquery(ora,'select * from USER_HF_TEST.view_dlfx') where fxrq >= '1900-01-01' and fxrq <= '2003-3-25' and ( JH ='23' or JH ='26')group by yhh,JH 这段码为连接服务器的,不能进行修改。
FROM
(
select yhh as A,jh AS B,SUM(hjdf) AS C from
(select * from USER_HF_TEST.view_dlfx)AA
where fxrq >= '1900-01-01'
and fxrq <= '2003-3-25'
and ( JH ='23' or JH ='26')group by yhh,JH
) T1
LEFT JOIN
(
SELECT DLYH.YHH AS M,DLYH.JH AS N
FROM T1,DLYH
WHERE (DLYH.JH=T1.B AND DLYH.YHH=T1.A)
)T2
ON (T1.A=T2.M AND T1.B=T2.N) WHERE (T2.M IS NULL AND T2.N IS NULL)
错误提示的就是这不对,请问如何解决?
select yhh as A,jh AS B,SUM(hjdf) AS C from
openquery(ora,'select * from USER_HF_TEST.view_dlfx')
where fxrq >= '1900-01-01'
and fxrq <= '2003-3-25'
and ( JH ='23' or JH ='26')group by yhh,JH
这段码为连接服务器的,不能进行修改。