declare @UseId select iTypeId from tType where iProjectId=73
select * from tProjectTypes where iTypeId = @UseId
这样不行吗?取到的@USERID在第二个语句中起不了作用?
select * from tProjectTypes where iTypeId = @UseId
这样不行吗?取到的@USERID在第二个语句中起不了作用?
select @UseId = iTypeId from tType where iProjectId=73
select * from tProjectTypes where iTypeId = @UseId
为1,没有就为0,怎么写这个sql
select A.*, (Case When B.iTypeId Is Null Then 0 Else 1 End) As Flag
from tProjectTypes A Left Join tType B On A.iTypeId = B.iTypeId And B.iProjectId = 73