deleting and table join

[dmcglone]

I am having a really hard time understanding how to delete when using a table join. I've looked up examples on here and on the web and I've tried to adopt them to what I need and I'm not having any luck.

I have a table named properties and a table named additional_info, and all I am trying to do is delete the corresponding information in the additional_info table that goes to the MLS_id it is joined with in the properties table.

Here's some code I have been playing with

 

$MLS_id = $_GET['MLS_id'];
    $this->query = ("DELETE properties, additional_info
    FROM properties
    LEFT JOIN properties.MLS_id ON additional_info.info_id = properties.MLS_id
    WHERE additional_info.info_id = $MLS_id");

 

Where am I going wrong?

 

Thanks,

David M.

[Barand]

Do you want to delete the rows from both tables or just from additional_info?

[dmcglone]

Both tables.

[Barand]

DELETE properties, additional_info

FROM properties

    LEFT JOIN additional_info ON additional_info.info_id = properties.MLS_id

WHERE properties.MLS_id = $MLS_id

[dmcglone]

Thank you. I think I understand. It'll probably take me a few minutes to wrap my head around it, after that I'll be asking myself "What was I thinking?"

[Barand]

Is this now solved?

[dmcglone]

Is this now solved?

Yes. I appreciate the help. I forgot to also mark the thread as solved.. (I'll do that now)

[Barand]

mysqlquestions - I think we've already established that, but thanks for your advert