level 1
万里水源
楼主
要使用两条语句针对5210与524两个的不同条件提出查询:
select sUserDN,sUserLRN,iClINEntIdx&1,iCdINEntIdx&1 from dbo.tbl_UsrProp where (iClINEntIdx&1)<>1 and (iCdINEntIdx&1) <>1 and sUserLRN like '5210%' order by sUserLRN
select sUserDN,sUserLRN,iClINEntIdx&1,iCdINEntIdx&1 from dbo.tbl_UsrProp where (iClINEntIdx&1)<>1 and (iCdINEntIdx&1) <>1 and sUserLRN like '524%' order by sUserLRN
查询结果为两个结果,，能否用一条语句直接查询到一个结果中?
2018年03月19日 01点03分
1
select sUserDN,sUserLRN,iClINEntIdx&1,iCdINEntIdx&1 from dbo.tbl_UsrProp where (iClINEntIdx&1)<>1 and (iCdINEntIdx&1) <>1 and sUserLRN like '5210%' order by sUserLRN
select sUserDN,sUserLRN,iClINEntIdx&1,iCdINEntIdx&1 from dbo.tbl_UsrProp where (iClINEntIdx&1)<>1 and (iCdINEntIdx&1) <>1 and sUserLRN like '524%' order by sUserLRN
查询结果为两个结果,，能否用一条语句直接查询到一个结果中?