Not unique table/alias: 'q'

Gee Bee · February 5th, 2006, 05:56 AM

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

Thanks for any help

Gareth

Ward · February 5th, 2006, 07:05 AM

Not sure if this is the reason. From MYSQL

Quote:

Note: In MySQL 4.0, you should refer to the table names to be deleted with the true table name. In MySQL 4.1, you must use the alias (if one was given) when referring to a table name:
In MySQL 4.0:
DELETE test FROM test AS t1, test2 WHERE ...
In MySQL 4.1:
DELETE t1 FROM test AS t1, test2 WHERE ...

I use aliases for selects in 4.0.25 but have not used them for a delete.