MySQL Forums
Forum List  »  Microsoft SQL Server

Query is not executing in Mysql which is correct in sql 2000
Posted by: Mohsin Syed
Date: May 16, 2005 04:28AM

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

Options: ReplyQuote


Subject
Written By
Posted
Query is not executing in Mysql which is correct in sql 2000
May 16, 2005 04:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.