Deleting rows with MySQL LEFT JOIN?

You simply need to specify on which tables to apply the DELETE Delete only the deadline rows: DELETE `deadline` FROM `deadline` LEFT JOIN `job` Delete the deadline and job rows: DELETE `deadline`, `job` FROM `deadline` LEFT JOIN `job` Delete only the job rows: DELETE `job` FROM `deadline` LEFT JOIN `job`.

You simply need to specify on which tables to apply the DELETE. Delete only the deadline rows: DELETE `deadline` FROM `deadline` LEFT JOIN `job` .... Delete the deadline and job rows: DELETE `deadline`, `job` FROM `deadline` LEFT JOIN `job` .... Delete only the job rows: DELETE `job` FROM `deadline` LEFT JOIN `job` ....

1 Also use "status in ('szamlazva', 'szamlazhato', 'fizetve',.........)" – Salil May 4 '10 at 6:31 Thank you! I've never specified the tables yet (i've never deleted rows with a left join is true too) :) – fabrik May 4 '10 at 6:39.

DELETE FROM deadline where ID IN ( SELECT d. ID FROM `deadline` d LEFT JOIN `job` ON deadline. Job_id = job.

Job_id WHERE `status` = 'szamlazva' OR `status` = 'szamlazhato' OR `status` = 'fizetve' OR `status` = 'szallitva' OR `status` = 'storno'); I am not sure if that kind of sub query works in MySQL, but try it. I am assuming you have an ID column in your deadline table.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.