Syntax error in select statement
Posted by:
Jon Ken
Date: June 09, 2005 10:40AM
Hi,
I use MySQL 4.0.18 in Linux environment, and I'm new to MySQL. I can get the returned records if I run the following SQL statement in Oracle. But I got syntax error when I run the following SQL statement in MySQL. Can someone tell me what the wrong is with the following SQL statement? Thanks a lot!
select hostname, vendor from serverinfo where vendor IN (select v_name from vendor);
Best Regards,
Jon
Subject
Written By
Posted
Syntax error in select statement
June 09, 2005 10:40AM
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.