Deleting from three tables at once

Hi All
Can someone tell me if this is possible or do I need to wake up. I'm trying to delete some records from three different tables at once via check boxes, tabls don't have any join. This doesn't give me any error but not working either. It does work with ONE table at a time thou. some help will be greatley appreciated.

		if($_POST['delete']) {
		foreach($_POST as $job_id) { 
		mysql_query("DELETE FROM job_tb,blockBook,blockBook2
		 WHERE job_tb.job_id='$job_id' OR 
		 blockBook.job_id= '$job_id' OR 
		 blockBook2.job_id= '$job_id'"); 
		if (mysql_affected_rows() > 0) { 
    	print "<font color=red size=2>Job No. = $Job_id has been deleted</font><p>"; 
  		} 
	}
}

Code (markup):

Thanks
Zed

 

I think... you can't do this...
you need 3 queries for 3 tables

 

DELETE 
	job_tb, blockBook, blockBook2
	FROM
		job_tb, blockBook, blockBook2
	WHERE
		job_tb.job_id = '$job_id' AND
		blockBook.job_id = '$job_id' AND
		blockBook2.job_id = '$job_id'

Code (markup):