MySQL Forums
Forum List  »  New in 4.1: Subqueries

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

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

Options: ReplyQuote


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


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.