MySQL Forums
Forum List  »  Microsoft SQL Server

Unable to JOIN view and a table in MySQL
Posted by: Sonia Agrawal
Date: February 24, 2010 09:59PM

Hi

I am trying to migrate from MS SQL Server 2005 to MySQL. I have several VIEWS in my database. When I tried to create the same VIEWS in MySQL, the CREATE query kept executing for several minutes without giving any error but didnot create the VIEW. The VIEW I was trying to create was joining an existing table and an existing VIEW. When I tried executing the same query as a SELECT statement joining a VIEW and a table, the query did not execute either and kept on running without throwing any errors.

Kindly help... I urgently need to setup this database in MySQL.

Thanks
Sonia

Options: ReplyQuote


Subject
Written By
Posted
Unable to JOIN view and a table in MySQL
February 24, 2010 09:59PM


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.