select所有结果 from incJobDemand a
where 条件2 and 条件3
and incLocation
in (select incLocation
from incInformation b
where a.incID =b.incID )
where 条件2 and 条件3
and incLocation
in (select incLocation
from incInformation b
where a.incID =b.incID )
解决方案 »
- 求tsql语句或存储过程:根据一表给另一表填充(update)分数
- VS2008 c#中如何通过buttonfield把一张表的数据移到另一张空表,如图所示
- sqlserver2000中如何查找已经建立的索引
- 急 請教
- SQL Server Configuration Manager打不开了,mmc错误
- 请教access 的行转列问题
- 有没有办法可以在VB中调用SQL SERVER的语法检查功能?可以再加分……
- VB+SQLSERVER
- 求助:请问各位大虾哪儿可以找到关于数据库的示例及源程序?!
- SQL SERVER多表合并
- asp编程需要 : SELECT FirstName + ' ' + LastName + Address, + CHAR(13) + City, + Region 希望使用回车时 出错
- 急!这样建索引对不对?
incLocation = lostAngel , workExpDemand = 2 , jobsortID = IT就写
select * from incJobDemand a
where workExpDemand=2 and jobsortID=IT
and incLocation in
( select incLocation b from incInformation where incLocation=lostAngel and a.incID=b.incID )对不对呢?
比如我想要
incLocation = lostAngel , workExpDemand = 2 , jobsortID = IT
就写select * from incJobDemand AS a
( select incID from incInformation AS b where incLocation=lostAngel )
where workExpDemand=2 and jobsortID=IT
and a.incID=b.incID