MYSQL :: Trouble Ordering By An Alias

Can I Check The Value Of An Alias(i Think Its Called An Alias) In A Query.
I was wondering can I check the value of an alias(i think its called an alias) in a query.

At the moment I have this but its not working:

MySQL Code:

SELECT * , ( DAYOFYEAR( ToDate ) - DAYOFYEAR( FromDate ) ) AS NumDays
FROM `tbl_courses`
WHERE NumDays < 3 AND NumDays > 2 AND FromDate >= &#55614;&#57159;-10-17'
ORDER BY FromDate

Alias Name Not Known
The bug I get is "Unknown column 'debt' in 'where clause'" . Why?

SELECT * , ventas.importe_acordado - SUM(cobros.nombre) , ventas.importe_acordado as nombre_venta
FROM ventas
INNER JOIN cobros
ON cobros.venta = ventas.id
WHERE debt > 0
GROUP BY ventas.id

Alias Error
error: Not unique table/alias: 'u'

sql: DELETE u.*,i.*,p.* FROM onig_users u, onig_users_info i, onig_users_profile p WHERE u.users_id=i.users_id AND i.users_id=p.users_id AND u.users_id = 23

i use this same syntax for a different design and had two tables instead of three and it works so I'm confused. Is there something different I should be doing for three tables?

Database Alias
Is it possible to create a database alias? I would like to have something like a symlink to another database. Let's say we have database "gurg" and this one should also be accessible through the name "garg". Is there a way to achieve this?

Dynamic Alias
I'm trying to output the previous 12 months and have the month name as the column heading. It doesnt want to let me use a function as the alias.

CODESELECT Department,
SUM(case when Month=MONTH((CURDATE() - INTERVAL 11 MONTH)) then Total else '0' end) AS DATE_FORMAT((CURDATE() - INTERVAL 11 MONTH), '%M-%Y'),

SELECT Alias
Is it possible to use an alias in the expression for another alias, for example:

SELECT net,
tax_rate,
net / tax_rate AS tax,
net + tax AS gross
FROM items

But that dosent work, mysql dosent allow an alias in the SELECT statement (says it cant find a field called tax), which is kind of annoying as it means i have to duplicate all my calculations like this:

SELECT net,
tax_rate,
net / tax_rate AS tax,
net + (net / tax_rate) AS gross
FROM items

This might not seem like a big deal in this query, but i have some other far more complicated queries where its just a pain. Is there any way to do this, it seems like it should be possible.

Sum Alias Column
I have a database mysql 5.0.51a-community with bookings.
I want to know how many days or weeks has been rented last year compared to this year.
The bookings I insert with arrival and departure date in 2 date type columns.
I do not know how to do it, they way I see it, I must count the days in every booking then sum the days.This seems a good way to me, but gives me error #1054 - Unknown column 'dias' in 'field list'
SELECT arrival, departure TO_DAYS(departure) - TO_DAYS(arrival) as days, typebooking, SUM(days) FROM bookings where typebooking = 'client' and year(arrival) = '2007'

As I understand the error, I can´t sum an alias column,...I could maybe do it with php, but don´t want to do a page for it, and must be a way to do it just with mysql.

Select Against Alias
Code:
SELECT COUNT(things) AS totalthings WHERE totalthings!=0;

> ERROR 1054 (42S22): Unknown column 'totalthings' in 'where clause'

How can I query against an alias, like above? It's late so maybe I'm missing something obvious..

Alias Problem
I get this error Unknown column 'n.nid' in 'on clause' when I run this query.Code:

SELECT DISTINCT(n.nid), e.event_start FROM event e
INNER JOIN node_access na ON na.nid = n.nid
INNER JOIN node n ON n.nid = e.nid
WHERE (na.grant_view = 1 AND
CONCAT(na.realm, na.gid) IN ('all0','simple_access0'))
AND n.status = 1 AND (
(e.event_start > 1138766400 AND e.event_start < 1141185599)
OR (e.event_end > 1138766400 AND e.event_end < 1141185599)
OR (e.event_start < 1138766400 AND e.event_end > 1141185599))
ORDER BY event_start;
Since node n is declared I can't see what's wrong.

Can A Query Alias Be Used As A URL Parameter?
Question: Is is possible to use an alias created in a MySQL query as a URL parameter? (I'm not sure if this is a MySQL issue, a PHP issue, both, or neither). My database table uses self-referencing ids to establish hierarchy. In the temporary example below flow is my PK, and both parent and top are self-foreign. .....

Using Column Alias Name In WHERE Clause
I am giving alias name to the column in SELECT clause and when I am using same alias name in WHERE cluase, it is giving error.

We can use alias names in WHERE clause.

Is there any solution or other way to achieve same functionality?

QUERY:
select concate(firstname, " ", lastname) as name
from user
where name = "Chetan Parekh";

Alias Using Unicode Character
how to use the micro sign in an alias? I want the column name to appear as "Chl (Âµg/L)".

Column Alias On Mass
Is possible to retrieve all columns and alias them all at once. Eg, normally
you would write

select * from products which would return

id | name | price
-----------------------
1 | Test | 14.00

but I want to be able to say

select p.* from products p, so that it returns the columns as such

p.id | p.name | p.price

Obviously I can do this manually as such

select p.id, p.name, p.price from products p ....

But that would take a lot of big queries as some of my tables have 50
columns.

Column Alias And HAVING Clause
I am having problems with the HAVING clause. I know it can use aliases
but the alias I am using has a space in it, eg 'Device ID'

My querry looks like (simplified, devID is a calculation)

SELECT devID AS 'Device ID' FROM tblDevice HAVING 'Device ID' = '123'

and it does not work

but if I use

SELECT devID AS 'Device_ID' FROM tblDevice HAVING Device_ID = '123'

everything works.

How can I use an alias that contains a space in the HAVING clause?

Every Derived Table Must Have Its Own Alias
i have a sub-query i'm trying to execute as follows....and i'm getting the above error message.....

select z.date from (select x.date from bsmtruckrecord as x where x.employee_ida=17) where z.date in (select y.holiday from bsmpublicholiday as y) as z

i have referenced all tables by an alias and i'm still getting the error message saying....
"every derived table must have its own alias"

Not Unique Table/alias
I've written SQL before and I'm sure this is close to correct, but I have never written SQL for MySQL. Where am I going wrong? I'm getting a Not unique table/alias: 'movies' error.

SELECT movies.ID, movies.Title, movies.GenreID, movies.RatingID, movies.UserID, Genres.ID, Genres.genre, Ratings.ID, Ratings.rating, Users.ID, Users.FirstName, Users.LastName, Users.Email, Users.Phone
FROM ((movies INNER JOIN Genre ON movies.GenreID = Genres.ID), movies ON Ratings.ID = movies.RatingID), movies ON movies.UserID = Users.ID

Getting Not Unique Table/alias
Can anyone tell me why im getting this error;

Not unique table/alias: 'q'

When running the following query;

DELETE q.*, r.* FROM questions AS q, replies AS r WHERE r.id_question = q.question_id AND q.question_id = 55

When were alias's first done be mysql as i've just discovered that my provider are running version 4.0.25.

Column Alias In WHERE Clause
I wana select 2 fields of a table as a variable and then in that query use that variable like this
SELECT money1+money2 AS money WHERE money > 10000
but mysql return an sysntax error Is there any way to use a varible like this in a query?

Union Result Going To Other Table Alias
I need to check two tables for a value of 'pending'. Now, this value might exist or might not. So i figured a union would do the trick.

MYSQL
SELECT cats AS alias_one FROM table1 WHERE FIELD = 'pending'UNIONSELECT dogs AS alias_two FROM table2 WHERE FIELD = 'pending'
but if table2 is the only table with the result, mysql returns the contents of col_two but under the alias: alias_one.. how can i get around this?

Not Unique Table/alias: 'tbl_products'
I have the following

SELECT tbl_products.product_id,
tbl_products.product_MerchantProductID,
tbl_prdtscndcats.scndctgry_ID,
tbl_prdtscndcats.scndctgry_Name,
tbl_prdtscndcat_rel.prdt_scnd_rel_product_id,
tbl_prdtscndcat_rel.prdt_scnd_rel_scndcat_id
FROM tbl_products, tbl_prdtscndcats, tbl_prdtscndcat_rel

LEFT OUTER
JOIN tbl_products
ON tbl_products.product_id = tbl_prdtscndcat_rel.prdt_scnd_rel_product_id
LEFT OUTER
JOIN tbl_prdtscndcats
ON tbl_prdtscndcats.scndctgry_id = tbl_prdtscndcat_rel.prdt_scnd_rel_product_id

It's saying Not unique table/alias: 'tbl_products'.

Is there anything wrong with the SQL?

Cannot Refer To Alias In Mysql Calculation
Allright, newest problem. I am trying to do most of my calculations in mysql rather than PHP since that makes using the data a lot easier. The problem is I can't seem to use aliases I've assigned to data in further operations.

This query:

SELECT
SUM(CASE WHEN correct = 'y' THEN 1 ELSE 0 END) as top,
SUM(CASE WHEN correct = 'n' THEN 1 WHEN correct = 'y'
THEN 1 ELSE 0 END) as bottom,
ROUND((top/bottom)*100,1) as percent
FROM quiz_answers
LEFT JOIN quiz ON quiz.ID = quiz_answers.quizid
LEFT JOIN cadets ON quiz_answers.cadet_id = cadets.cadet_id
WHERE flight='$row[flight]' AND due>='$start' AND due<='$end'
Does not give me the percent. I get this error.
Quote:

Unknown column 'top' in 'field list'

That is true, there is no column top I wanna use the sum i just assigned as top.

I don't want to put the SUMs in the round function because I may need to use that data too.

Derived Table Alias Error
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24-community-nt]Every derived table must have its own alias

is the ERROR displayed and my QUERY is....

Use An Alias Name For A Field In A Join Ation
I'm using a select like this:

SELECT * FROM `CPESER` INNER JOIN `CONCPE` ON `CPESER`.`id_concpe` = `CONCPE`.`id`
LEFT JOIN `CADSER` ON `CPESER`.`id_cadser` = `CADSER`.`id` LEFT JOIN `CADPRO`
ON `CADSER`.`id_cadpro_data`= `CADPRO`.`id` AND
`CADSER`.`id_cadpro_voice` = `CADPRO`.`id` LEFT JOIN `CONASS` ON
`CONCPE`.`contract` = `CONASS`.`contract` INNER JOIN `CADCLI` ON
`CONASS`.`id_cadcli` = `CADCLI`.`id` ORDER BY `CADCLI`.`name`

but there is a problem: some colums has the same name... it's possilbe to use aliases to the fields?

Alias Mysql ERROR 1064
I am trying to configure the mysql install, following the instructions in the manual, specifically the alias to the mysql path and I get the following error:

mysql> alias mysql=/usr/local/mysql/bin/mysql/
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alias mysql=/usr/local/mysql/bin/mysql/' at line 1

Create A Dynamic Alias Name Using A Function
Is this possible?

SELECT

sum(if(EXTRACT(YEAR_MONTH FROM hitdate) = EXTRACT(YEAR_MONTH FROM
now()),1,0)) as EXTRACT(YEAR_MONTH FROM now())

FROM TABLE_NAME

SQL, Field Name Alias For Write Access
I get an error on the adorec.update line - Unknown column 'MyName' in 'field list'. The code will work for read access but won't let me write to it. How do I update a field with an alias?

I know i can lose the "AS" part but that would defeat the purpose of what I'm accually trying to do.

Strange Alias And Join Problem On Server But Not Dev Box
I'm running MySQL 5.0.45, php5 and apache 1.3 on windows xp for development. All my tables are MyIsam.
The following query works fine :

MySQL
SELECT
i.image_id, image_filename, region_name, monument_name
FROM
image AS i
LEFT JOIN
image2region USING(image_id)
LEFT JOIN
region USING(region_id)
LEFT JOIN image2monument AS i2m ON (i.image_id=i2m.image_id)
LEFT JOIN monument USING(monument_id)
WHERE region_name='egypt'
LIMIT 0, 8
On the server (MySql v5.0.15) where I plan to host the site I get the following error:

#1054 - Unknown column 'image_filename' in 'field list'

If I give all the tables aliases and prepend all the column names after the SELECT with the aliases it works but I don't want to have to do this with all the queries I've written. I don't understand why it doesn't work on my dev box but not the hosts server.

I have also noticed that this problem only seems to arise on queries with more than two joins.

Has anyone else experienced a problem like this?

Or should I be prepending all columns with aliases as a matter of good practise anyway?

Cheers x

Error 1066 Not Unique Table/alias
I want to select 2 names from Person table. I think a join table would be overboard for this simple requirement, let me know.

person (table)
- id_person
- name

place (table)
- id_place
- name
- id_person1 [fk person.id_person]
- id_person2 [fk person.id_person]

SELECT place.name AS place_name, person.name AS name1, person.name AS name2
FROM place
INNER JOIN person ON place.id_person1=person.id_person
INNER JOIN person ON place.id_person2=person.id_person

ERROR 1066 (42000): Not unique table/alias: 'person'

Wanting output as
place_name: "This Place"
name1: "Fname Lname"
name2: "Fname Lname"

Derived Tables / Alias Error When Doing A Union
I am running version 4.1.1a of MySQL server, and I am running into a problem. The below SQL query causes an error, saying:

[MySQL][ODBC 3.51 Driver][mysqld-4.1.1a-alpha-nt]Every derived table must have it's own alias

I have looked at this query up and down and can't find anything wrong with it. I did find somewhere that there is possibly a bug with MySQL and this issue? But according to what I read, it had already been fixed in this version? Is the probem with my code, or is it a bug in the MySQL version that I have? Code:

ERROR 1066: Not Unique Table/alias: 'person'
The database 'testdb' has 2 tables, 'person' and 'team', which have the same structure. I tried the query "LOCK TABLES team READ, person AS team WRITE;", and got the following error: ERROR 1066: Not unique table/alias: 'person' What is the worry?

Trouble With MAX
I can't seem the get the MAX to work. I'm not getting any errors, but it doesn't show any results. I want to show the last Samples order ID that was used for putting in new sample sales, so that we know which number is next. All sample order ids begin with S. Here is the query: Code:

Having Trouble With An SQL Statement
I have the following tables (only relevant fields are shown):

competitions
id = competition ID

portfolios
id = portfolio ID
comp_id = competition ID

actions
port_id = portfolio ID

What I want to do is put together an SQL statement that, when given the competition ID, will delete all portfolios that have that comp_id and all actions have the port_id of one the deleted portfolios.

That is, there is many portfolios for each competition. There is many actions for each portfolio (and therefore with each competition). I want to delete everything that has to do with the specified competition.

Trouble With Exists
This query looks perfectly fine but I keep getting an error.

MySQL
SELECT jobId
FROM jobs
WHERE EXISTS (
SELECT jobId
FROM workOrders
WHERE workOrders.jobId=jobs.jobId
AND workOrders.status <> 7 AND workOrders.status <> 6
)
Here is the error

#1064 - You have an error in your SQL syntax near 'EXISTS (
SELECT jobId
FROM workOrders
WHERE workOrders.jobId=jobs.jobId
' at line 3
Does anyone see anything wrong with this?
I'm starting to think I'm brain dead.

Trouble With Insert Last ID
I have a form that is completed and some data is put into a table called workorder, the images uploaded go into a table called images and the parts go in a table called parts.

I need to be able to retrieve these items so I have created tables that will tie the parts and images into the workorder table. (workorder_parts and workorder_images)

The problem is that when I try to get it to use the last_insert_id() it is only putting a 0 in the field. The other issue is that I am not sure how to tie in multiple rows from each workorder together. By this, I mean that their could be up to 4 images or 7 parts inserted into the table for each workorder.

This is how I have it setup right now, but it isn't working. The initial data is going into the workorder, parts and images tables, but no data (only zeros) is going into the table that ties them together.

mysql_query("INSERT INTO workorder (work, name, sched, site, serial, hours, starts, issue, severity, resolution, assistance, safety) VALUES ('$work', '$name', '$sched', '$site', '$serial', '$hours', '$starts', '$issue', '$severity', '$resolution', '$assistance', '$safety')") or die(mysql_error());
//mysql_query("INSERT INTO workorder_parts (number, workorder_work_id) VALUES ('number[]', 'last_insert_id')")or die(mysql_error());
mysql_query("INSERT INTO workorder_image(image_image_id,workorder_work_id) VALUES ('$image_id', 'last_insert_id()')")or die(mysql_error());

mysql_query("INSERT INTO `image` (Upload) VALUES ('$file_name')")or die(mysql_error());

$query = "INSERT IGNORE INTO parts (description,number) VALUES ('" . $description[$key] . "', '" . $val . "')";
mysql_query($query) or die(mysql_error().$query);

Trouble After Going To New Server
Our website has recently been moved to another server. Since then I've noticed that my MySql queries look like this:

WHERE `firstname` LIKE CONVERT( _utf8 'john' USING latin1 )

Instead of this:

WHERE `firstname` LIKE 'john'

I'm not sure what is happening or why. Everything seems to be working fine, but I'm wondering if this is a problem I need to fix to avoid issues down the road.

Trouble With A Date
I used 'Date' for the date field in a database. I try to date_format it, but it will only let me have the date with the year first etc.

Is this the way it is with the Date property?

Each of the tutors I'm using seems to have a different preference - Date, Timestamp etc. Is there a best property to use for dates, please, experts?

Trouble Assigning Value
in my code i have the following:
tableName!Date = "2006/12/07", where "Date" is the name of the column in the mysql table and it is defined/has a type of datetime..

When i get to this line of code however, the value of date stays null. Ive managed to assign other fields in the table similarly (e.g. tableName!fname = "Frank".) I believe it may also be a keyword and thats my problem, but I'm uncertain.

Does any one have any suggestions as to why this wont work for the date field?? If its due to the fact its a keyword, how can i still pass the value without changing the column name in the table?

Trouble With 'insert'
I'm trying to insert multiple names in a table and it doesn't want to work... I am a complete noob, sorry.

this is the code that doesn't work, i get an unspecified error.

insert into delegates (delname) VALUES (“Watkins M Abbitt Jr”, “David B Albo”, “Kenneth C Alexander”)

Connection Trouble
Im having trouble connecting to a database on a remote server, i didnt have problems before and cant understand why im suddenly having problems now. The error message i get is "Cant connect to MySQL server on (name of server here) "
Im using a program called MySQL-Front as ive not got phpmyadmin installed on the remote host.

Trouble With A Query
Im dealing with two tables student(columns are sno, sname, address, and sex) and results(columns are cno, sno, and score). I need a query of he snames of femal (sex = 'f') students who take every course taken by J. Brown (sname). So far I have:

Code:

SELECT student.sname FROM student, result WHERE student.sno = result.sno AND student.sex = 'F';

Now what I am having trouble with is finding the females who are in every course with J. Brown. Now cno from the result table is the course number I need to do something with that but I'm not sure what. Do I need to use a GROUP BY or something along those lines?

Mysql Import Trouble
I'm using the following code to import a .sql file.

mysqlimport --local -u root -pCENSORED teraspot_db /home/default/teraspot_db.sql
and I get this error

mysqlimport: Error: Table 'teraspot.teraspot_db' doesn't exist, when using table: teraspot_db
I got the .sql file from exporting the database in phpmyadmin on the old server.

What am I doing wrong?

Trouble Installing MySQL On Mac OS 10.4
I'm working on a Mac under OS 10.4
In the hopes of making my website interactive I've been trying to use Kevin Yank's book "Build Your Own Database Driven Website Using PHP and MySQL" to learn some MySQL and some PHP. (At the moment I know only a tiny bit about PHP and nothing about MySQL.)

Despite my determination to go about this in a calm and orderly way, I've run into a frustrating obstacle right at the beginning. To make matters worse, I'm not even sure what the problem is, which makes it difficult to ask for help. I don't know whether MySQL is actually installed and I just don't know how to use it or whether, despite my efforts, it's not really installed at all. I tried to install it according to Kevin's instructions and thought it had been installed properly (I mounted the dmg and a "startup package appeared in my Library, but when I tried to proceed farther by typing commands into a Terminal window according to Kevin's instructions, I just got a "command not found" response.) I read what Apple has to say about installing MySQL under OS 10.4 and tried again, but when, following their instructions to make sure no MySQL processes were already running before installing I entered "mysqlshutdown admin" once again I got a "command not found".

One other thing: I think the problem (or part of the problem) might be that I'm not in the right directory when I type in these commands. I get the impression MySQL stuff is supposed to be happening in the "root" directory, but when I type in "cd root" in the Terminal window I just get another "command not found." (Before I started to work on this yesterday I'd never used a Unix terminal window!)

I'm a bit embarrassed and hesitant about this post â€” my first on this forumâ€” because I'm afraid it's going to sound very ignorant and confused. But you do say beginners are welcome so....

Trouble Decrypting Using AES_ENCRYTPT()
I am using AES_ENCRYPT() in my php-based SQL query. The field I am encrypting into is of type BLOB. It was varchar(100) but I read where that might be causing the issues but it is still having issues decrypting.
When I go to AES_DECRYPT(), using the same salt string, most decrypt fine but randomly there are several out of 20 that do not decrypt, that is they decrypt = null.

Trouble With Indexes And Inserts
Here's the situation(mysql 5.1)
(all the sql commands are below for easy replication)

If I put an index of length shorter than the field it is based on, I can't insert a row into a new table if that row has a value of that field longer than the index but shorter than the field definition. This is probably not a completely accurate description, but I'll show what I mean by a simple sequence.

1.Create two tables. table 1 is the source. table2 will be getting the inserts. table1 has an index (ix_org) which is 10 long, while org, the field it is based on is 30 long.

create table table1 (
name varchar(30),
place smallint,
org varchar(30),
index ix_org (org(10))
) engine = MyISAM;

create table table2 (
name varchar(30),
place smallint,
org varchar(30),
place_total varchar(10)
) engine = MyISAM;

2. Insert some data into table1. Two rows: one row with a "org" field length shorter than 10 and another with a field length longer than 10.

insert into table1 (name, place, org)
values ('Joe',Ƌ',ƍ_chars'),
('Fred',ཆ',ཉ_characters');

3. now do the inserts

test 1:

insert into table2 select
name as name,
place as place,
org as org,
concat(place,'/', (select max(place) from table1 where org=ƍ_chars')) as place_total
from table1 t1;

Result: all is good. in this case we are joining (in the subquery) on a value of "org" which is less than 10 characters > two rows inserted.

test 2:

(now join in the subquery with field length of org longer than 13)

insert into table2 select
name as name,
place as place,
org as org,
concat(place,'/', (select max(place) from table1 where org=ཉ_characters')) as place_total
from table1 t1;

Result: does not insert. error "data too long for column org at row1".

Other tests:
* if the length of the index is made the same length as the field, the error doesn't occur.
* if the subquery is not in the insert command, the error doesn't occur.

Select Statement Trouble...
I thought I could do a comparison in my SQL statement and get data from Wednesday to Wednesday but I do not know how to tell if my date of entry (which is set with the function NOW() when I write to the database) falls in the most current week.

Some psuedo code would be - Select * from conference_dates where date_of_submission is >= the previous wednesday and date_of_submission is <= today (meaning any day).

I can get any 7 days previous but I am not sure how to get only the number of days necessary (today would return 1 days records).

Trouble With Joining Tables
I'm having some trouble running the following query:

SELECT DISTINCT(im.id) FROM item_master im LEFT JOIN xref xr ON im.id = xr.item_master_id WHERE im.item_number LIKE '%100%' OR xr.oem LIKE '%100%'

For some reason, the query takes 2 minutes to execute. If I remove the bit that says "im.item_number LIKE '%100%'", or change it to compare data from the joined table (eg. "xr.item_number LIKE '%100%'"), the query is executed in 31ms.

Trouble With Id + 1 When Inserting Data
I'm trying to find a good alternative for auto_increment, the reason is that I need to know what the next value of id will be before inserting data into the table and I haven't found a relyable way of doing that with auto_increment.

My plan was to use a commend like:

INSERT INTO temp (id, test) VALUES (MAX(id)+1, 'foo')
But I am getting the error: ERROR 1111 (HY000): Invalid use of group function.

Trouble Creating Tables
I'm trying to write a PHP script to create a MySQL table. When I try to run the script, it won't create the table. I noticed that it will create it if I don't put "auto_increment" or "Primary key" in the script. If I take those two things it works great, but when I try to put that in, it fails.....

Having Trouble With Subqueries With Mysql 4.0.21
i'm trying to make this command run:

select MAID from spez_MA where MAID = any(select MAID from spez_P_MA where P_ID = 1)

on a mysql server 4.0.21. and i get an error

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( select MAID from spez_P_MA where P_ID = 1 )
LIMIT 0, 30' at

the command works using the same database in another mashine running mysql 4.1.22.

where can i find the documentation of the correct syntax for 4.0.21? my sintax is according with http://dev.mysql.com/doc/refman/4.1/en/any-in-some-subqueries.html, but this is for 4.1, not for 4.0. this manual should be for versions 3.23 and 4.0 too.