Probably there's nothing wrong with the query. The problem seems to be
that MySQL you're using (v3) does NOT support subqueries. Note that MySQL
v4.0, the actual production release, does NOT support subqueries either.
Subqueries are supported on MySQL v4.1, which is still in ALPHA stages
and is strongly NOT recommended for production servers.
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries
Sincerily,
Leonardo Rodrigues
----- Original Message -----
From: "Manoj Kumar Neelapareddy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 19, 2003 11:46 AM
Subject: might be a cilly question to u -execuse me.
> Hello Friends,
>
> i am new to mysql and plz don't treat my question as a
> cilly as i am just getting into mysql.
>
> my problem is:
>
> when i am executing the following query i am getting
> the error. whats wrong with the query? "desc" of table
> "accounting" and "user" and contents of them are also
> listed below.
>
> mysql version is :
>
> mysql Ver 11.18 Distrib 3.23.54, for redhat-linux-gnu
> (i386)
>
> mysql> select *from accounting where uid = (select uid
> from user wher gid="apswan");
> ERROR 1064: You have an error in your SQL syntax near
> 'select uid from user wher gid="apswan")' at line 1
> mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
