HEllo Team,
I have the following Query.
select ID,CUSTOMERLOANOCRID,FILELOGID,[FILENAME],BATCHID,RECORDNO,FIRSTNAME,
MIDDLENAME,LASTNAME,GENDER,FULLADDRESS,CUSTOMERADDR1,CUSTOMERADDR2,LANDMARK,CITY,STATE,
PINCODE , LANDLINENO, MOBILENO1 , MOBILENO2 , EMAILID , DOB , ADDRVERIFY ,
PHOTOVERIFY , LOAN1AMT , LOAN1INTRRATE, LOAN2AMT,LOAN2INTRRATE,DATEOFEMI,RELEASEDATE,
MOTHERNAME , HOUSETYPE ,COMPANYNAME,SALARY,IMAGENAME , IMAGERECORDNO, QCTOVERIFY ,
QCUSERID , CREATEDBY , CREATEDON , UPDATEDBY , UPDATEDON , DELETED ,QCUSERID ,QCTOVERIFY,
QCTOVERIFYREMARKS from CUSTOMERLOANDATA with(nolock)
where FILELOGID=(select top(1) filelogid from CUSTOMERLOANDATA with(nolock)
where isnull (QCTOVERIFY , 0) and QCUSERID = 13 order by id asc) and isnull (QCTOVERIFY, 0)
I am getting the error
Msg 4145, Level 15, State 1, Line 9
An expression of non-boolean type specified in a context where a condition is expected, near 'and'
Kindly tell me where i am making the mistake.
Thanks
Harshal Raut