这句话是错误的,请问该怎么改写select a.* ,b.* from (select guid from Rsst_FreqResource fr where RFR_USING='遥测、遥控、数据传输' and RFL_GUID='8c10aea9-6469-4865-ad5d-2363ce8978b3' and
Rfr_FreqLow*1000+Rfr_FreqWidth/2 >= 229025 and Rfr_FreqLow*1000-Rfr_FreqWidth/2 <= 230000 ) a left outer join
(select max(FFA_TYPE)-3 from rsst_freqassign fas where ('2008-11-27' between FFA_USELIMITDATEBEGIN and FFA_USELIMITDATEEND
and FFA_TYPE>0)or(FFA_TYPE=0)) b on a.GUID=fas.FR_GUID;
Rfr_FreqLow*1000+Rfr_FreqWidth/2 >= 229025 and Rfr_FreqLow*1000-Rfr_FreqWidth/2 <= 230000 ) a left outer join
(select max(FFA_TYPE)-3 from rsst_freqassign fas where ('2008-11-27' between FFA_USELIMITDATEBEGIN and FFA_USELIMITDATEEND
and FFA_TYPE>0)or(FFA_TYPE=0)) b on a.GUID=fas.FR_GUID;
解决方案 »
- 用js去掉扫描枪的自动提交事件【高分求高手指教】
- 对JSON是在是第一次接触:.net解析JSON,收不到传递的数组
- vs2005连接sql2005出错
- update在access里为做更新不了数据!
- C#2005 中连接字符串的问题。
- 这个东西表示的意思是否相同?如果不同,区别在哪?
- mvc简单问题
- 求实例!基于jQuery打造智能的人员选择输入框
- javascript中有没有判断是否是第一次加载的函数
- .net 中有一个“使用 XML 用户文件的窗体身份验证”例子,运行时有iis错误!
- 请教:奇怪的OCI-22053问题
- 如何让oledbdataadapter显示转换成oledbdataadapter
如果想用b表的,先把FR_GUID字段取出来,放在b表内,现在是没有的
Rfr_FreqLow*1000+Rfr_FreqWidth/2 >= 229025 and Rfr_FreqLow*1000-Rfr_FreqWidth/2 <= 230000 ) a left outer join
(select max(FFA_TYPE)-3,FR_GUID from rsst_freqassign fas where ('2008-11-27' between FFA_USELIMITDATEBEGIN and FFA_USELIMITDATEEND
and FFA_TYPE>0)or(FFA_TYPE=0)) b on a.GUID=b.FR_GUID;
这个语句
select guid fr_id,
(select max(FFA_TYPE) from rsst_freqassign where FR_GUID=fr.GUID and
('2008-11-27' between FFA_USELIMITDATEBEGIN and FFA_USELIMITDATEEND and FFA_TYPE>0)or(FFA_TYPE=0))-3 fassign,
(select count(*) from rsst_freqlink a,rsbt_freq b,rsbt_station c where a.FREQ_GUID=b.GUID and b.STATION_GUID=c.GUID and
a.FREQRESOURCE_GUID=fr.guid and c.STAT_STATUS!=2) fuse,
(select count(*) from Rsst_FreqScanResult where RFR_GUID=fr.GUID) fscan
from Rsst_FreqResource fr where RFR_USING='遥测、遥控、数据传输' and RFL_GUID='8c10aea9-6469-4865-ad5d-2363ce8978b3' and
Rfr_FreqLow*1000+Rfr_FreqWidth/2 >= 229025 and Rfr_FreqLow*1000-Rfr_FreqWidth/2 <= 230000 在sqlplus里面能运行,但在asp.net中不能运行,提示标识符过长,所以就想把这个语句再改下,改成上面的那样,请问怎么改