[RESOLVED] Deleting From Multiple Tables

obrienkev

Hi all,

I want to delete data from two tables. How do I do this? Below query doesn't work. Problem with syntax I think.
Get this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS s INNER JOIN details AS d ON s.ffnumber = d.ffnumber WHERE s

$query = "DELETE FROM student AS s ". 
			 	 "INNER JOIN ".
			 	 "details AS d ".
				 "ON s.ffnumber = d.ffnumber ".
			 	 "WHERE s.ffnumber = '$value' ".
				 "AND ".
				 "d.ffnumber = '$value' ";

leatherback

As far as I know, you cannot do it this way. you need to use two seperate queries.

mrhappiness

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

your mysql version is high enough?
why do you use an INNER JOIN, you have all the conditions in your WHERE? 😕

if s.ffnumber has the value $value and d.ffnumber has the very same value $value then s.ffnumber = d.ffnumber is always true, isn't it?

obrienkev

I used INNER JOIN to link the two tables. Should this be done another way??

Anyway just used two separate queries.

thanks.