strSQL.Format("SELECT ECC, ECONo, Other2 FROM ECOModifyManage WHERE State='正式' AND ECONO IN (SELECT ECONo FROM ECOHandout WHERE (ViewUser='' OR ViewUser IS NULL) AND Enpartment IN (SELECT Name FROM EnpartmentManage WHERE Manager='%s'))", m_userPrompt);
解决方案 »
- 关于条件
- 求一条语句
- inserted 的疑问
- 200分求一個俺幾年來沒法解決的問題:請問如何對SQLServer2000進行針對存儲過程的文本搜索?
- 终于升到两颗小豆豆了 ^_^ 好高兴啊
- 一个不是很难的问题!
- 求一条能将奇偶数分开的查询
- 80分求助,关于数据移植
- sql字符集如何修改?
- 救命呀。十万火急,我都要死了 300分求助
- 有没有辅助写SQL代码的工具??望不吝赐教!
- 为什么bcp "SELECT ID,SUBSTRING(ExternalKey,7,32),NodeID,PM_Product_ID,LB_Product_ID,StyleTypeID FROM ExternalMapping" out "Exter
SELECT ECC, a.ECONo, Other2 FROM ECOModifyManage a
Inner join (select ECONo from ECOHandout where ViewUser='' or ViewUser is null) b
On a.ECONo=b.ECONo
Inner Join (select name from EnpartmentManage where manager like '%s') c
On a.Enpartment=c.name where a.State='正式'
3楼的提示列名Enpartment无效,实际上Enpartment是在表b中,我改过来了,也还是提示这样的错误
strSQL.Format("SELECT a.ECC,a.ECONo, a.Other2 FROM ECOModifyManage a,ECOHandout b, EnpartmentManage c \
WHERE a.State = '正式' AND a.ECONo=b.ECONO AND b.Enpartment=c.Name AND ( b.ViewUser = '' OR \
b.ViewUser IS NULL) AND c.Manager='%s'",m_userPrompt);
表ECOHandout:列名: ECOG,ECONo,Enpartment,ViewUser,...
表Enpartment:列名:Code,Name,Manager,...
Inner join (select ECONo,Enpartment from ECOHandout where ViewUser='' or ViewUser is null) b
On a.ECONo=b.ECONo
Inner Join (select name from Enpartment where manager like '%s') c
On b.Enpartment=c.name where a.State='正式'