Not unique table/alias: 'q'

Gee Bee · #1 (**permalink**) Feb 5th, 2006, 08:56

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 · #2 (**permalink**) Feb 5th, 2006, 10:05

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
unique Clothings	yaodong	Free Web Site Critique	4	Mar 17th, 2007 16:45
mysql resource: Unique?	Compumaniac12	Databases	1	Sep 1st, 2006 21:05
Unique Web Design Opportunity	supastarz	Job Opportunities	0	Aug 8th, 2006 15:12
Domain alias redirection with PHP?	Tim356	PHP Forum	2	Dec 12th, 2005 03:26

		Webforumz.com > Main Forums > Program Your Website > Databases
Not unique table/alias: 'q'