MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Microsoft SQL -> mySQL
Posted by: Chris Chan
Date: September 07, 2004 11:11AM

I am not sure if this is the right forum to ask, but I have a Microsoft SQL statement which doesn't seem to work in mySQL:

select ProjectID,BugID,BugTitle from Bug where Cast(BugID as Char) + Cast(ProjectID as Char) not in (select Cast(BugID as Char) + Cast(ProjectID as Char) from BugTracking)

Anyone has any ideas how I can modify the above script to make it work in mySQL? If I run the above script, instead of giving me 4 records in MS SQL it is giving me over 1000 records in mySQL.

Thanks in advance.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Microsoft SQL -> mySQL
Chris Chan
September 07, 2004 11:11AM
Re: Microsoft SQL -> mySQL
Mike Hillyer
September 07, 2004 03:48PM


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.