List:General Discussion« Previous MessageNext Message »
From:Andrew Pattison Date:July 22 2004 10:10pm
Subject:Re: subquery problem.
View as plain text  
Subqueries aren't implemented in 4.0 - only 4.1 and upwards support
subqueries.

Cheers

Andrew.

----- Original Message ----- 
From: "nambi c" <hellonambi@stripped>
To: <mysql@stripped>
Sent: Thursday, July 22, 2004 10:31 PM
Subject: subquery problem.


> Hi,
>
> My server version :  4.0.18-max-nt
>
> I have created 2 tables 'channels' and 'users' in my
> database. I can query these tables individually. I am
> trying to execute a query with 'exists' clause.
>
> mysql> select * from channels where exists (select *
> from users);
>
> This give the following error.
>
> ERROR 1064: You have an error in your SQL syntax.
> Check the manual that corresp
> onds to your MySQL server version for the right syntax
> to use near 'exists (sele
> ct * from users)' at line 1
>
>
> I am getting this syntax error message. The query
> seems perfect to me. Any clue what is happening? Help!
>
> -Nambi
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail is new and improved - Check it out!
> http://promotions.yahoo.com/new_mail
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>


Thread
subquery problem.nambi c22 Jul
  • Re: subquery problem.Justin Swanhart23 Jul
  • Re: subquery problem.Andrew Pattison23 Jul