delete from multiple tables

[axman505]

I am having trouble trying to figure out a delete query to work accross multiple tables. right now, i have something like this:

DELETE from ad_bill_info as b, ad_cc as c USING b,c where b.cc_id = c.id and b.id = 2

Any suggestions?

 

[r937]

what version of mysql are you on? because the multi-table DELETE syntax is supported only in 4.0+

rudy

http://r937.com/

SQL Consulting

 

[axman505]

i am running 4.0.22

 

[r937]

did you try it without aliases?

DELETE from ad_bill_info, ad_cc USING ad_bill_info, ad_cc where ad_bill_info.cc_id = ad_cc.id and ad_bill_info.id = 2


rudy

http://r937.com/

SQL Consulting

 

[axman505]

thanks, that seemed to do it.