469,929 Members | 1,790 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,929 developers. It's quick & easy.

Multi table delete problem

Hello!

SELECT * FROM reviews AS r, reviews_description AS rd WHERE r.reviews_id =
rd.reviews_id AND r.products_id= 108;
works,

DELETE FROM reviews AS r, reviews_description AS rd WHERE r.reviews_id =
rd.reviews_id AND r.products_id= 108;

doesn't work.

why??

please help. thx!
Jul 19 '05 #1
2 1986
Because mysql doesn't support multi linked tables in delete statements.

Kinda pisses you off hey ?

Thanks

Aaron

"Soldier" <di**@DELME.rules.pl> wrote in message
news:br**********@inews.gazeta.pl...
Hello!

SELECT * FROM reviews AS r, reviews_description AS rd WHERE r.reviews_id =
rd.reviews_id AND r.products_id= 108;
works,

DELETE FROM reviews AS r, reviews_description AS rd WHERE r.reviews_id =
rd.reviews_id AND r.products_id= 108;

doesn't work.

why??

please help. thx!

Jul 19 '05 #2
Because mysql doesn't support multi linked tables in delete statements.

Kinda pisses you off hey ?

Thanks

Aaron

"Soldier" <di**@DELME.rules.pl> wrote in message
news:br**********@inews.gazeta.pl...
Hello!

SELECT * FROM reviews AS r, reviews_description AS rd WHERE r.reviews_id =
rd.reviews_id AND r.products_id= 108;
works,

DELETE FROM reviews AS r, reviews_description AS rd WHERE r.reviews_id =
rd.reviews_id AND r.products_id= 108;

doesn't work.

why??

please help. thx!

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gordon | last post: by
2 posts views Thread by Eric Haskins | last post: by
9 posts views Thread by cheryl | last post: by
4 posts views Thread by Andy_Khosravi | last post: by
2 posts views Thread by =?Utf-8?B?TU1TSkVE?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.