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

[Mohsin Syed]

Dear all,
We are migrating from MS-SQL to Mysql and I am getting problem while executing the following query in Mysql, which is working finely in MS-Sql 2000 server. Please help
the query is

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')