Delete from Two (2) tables

[Prellyan]

Hey there ...

There seems to be a few ways to do this however i am still a little confused.

 

I have two tables both have a common id field so to delete i thought would just be simple

 

DELETE auctionpropertyaddressdata,auctionpropertyimages FROM auctionpropertyaddressdata JOIN auctionpropertyimages ON auctionpropertyid WHERE auctionpropertyid=%s

 

not so ... can anyone resolve this for me?

 

Thanks

 

[phporcaffeine]

http://dev.mysql.com/doc/refman/5.0/en/delete.html

[Prellyan]

Thanks for that - but i am seriously stuck on the syntax

can you offer any other help as well please?

thanks

[phporcaffeine]

DELETE auctionpropertyaddressdata, auctionpropertyimages FROM auctionpropertyaddressdata INNER JOIN auctionpropertyimages WHERE auctionpropertyaddressdata.id=auctionpropertyimages.id;

[Prellyan]

that worked but it wiped out ALL records not just the selected recordID

 

DELETE auctionpropertyaddressdata,auctionpropertyimages FROM auctionpropertyaddressdata INNER JOIN auctionpropertyimages ON auctionpropertyid WHERE auctionpropertyid=%s

 

gives me this error

 

Column 'auctionpropertyid' in where clause is ambiguous

 

where just the recordID from the link is deleted not the entire set

 

thanks for help thusfar --- i am sure we can get it sorted

[fenway]

Use table aliases and prefixes.