[SOLVED] inner join help

[knowram]

I am new to using join and I don't see where my error is can someone help me out. thanks

$query = "DELETE
			FROM aDevice
			INNER JOIN aOffice
			ON aDevice.oNum = aOffice.oNum
			INNER JOIN aMember
			on aOffice.mNum = aMember.mNum
			WHERE
	`mNum` = '$_REQUEST[mNum]' LIMIT 1";
Mysql_query($query) or
	die (mysql_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 'INNER JOIN aOffice ON aDevice.oNum = aOffice.oNum INNER JOIN aMember ' at line 3

 

Thanks again for the help

[Illusion]

It should be something like this

DELETE * FROM aDevice,aOffice,aMember Where aDevice.oNum = aOffice.oNum	AND aOffice.mNum =aMember.mNum AND `mNum` = '$_REQUEST[mNum]' LIMIT 1";

It is very dangerous as we don't know which records it delete, I don't know LIMIT will work when there are multiple tables are involved.

and one more thing JOINS are for data retrieving/display purpose only, they don't form any physical structure.

 

[knowram]

Thanks for the help I figured out a way to do what i wanted