View Single Post
  #1 (permalink)  
Old Feb 5th, 2006, 08:56
Gee Bee Gee Bee is offline
Up'n'Coming Member
Join Date: Jan 2006
Location: East Sussex
Age: 26
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Question Not unique table/alias: 'q'

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
Reply With Quote