Query is not executing in Mysql which is correct in sql 2000

[Mohsin Syed]

Hello,

We are migrating from sql server to mysql and the following query is not working please help me


select P.PROP_SLS_PRC, P.REF_NO, P.PROP_ADDR, P.PROP_DESC, P.CONTACT_NO, P.PRMY_IMG, P.PROP_BDRM_NO, P.PROP_ID, P.PROP_LET_PRC from PROP_MST P where P.PROP_ID in(select UP.FK_PROP_ID from USER_PROP_MST UP where UP.FK_USER_ID =(select UD.USR_ID from USER_DTL_MST UD where UD.USER_NAME='mohsin') and UP.IS_DELETED='0')