Delete Related Table
| From: | Remon Redika | Date: | Mon, 03 Feb 2003 06:53:50 +0000 |
| Subject: | Delete Related Table | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-134085@lists.php.net to get a copy of this message | ||
hi everyone..
i need delete two related table from mysql database,
but i am found and error..
this following my sql language :
DELETE FROM X INNER JOIN Y ON X.ID = Y.ID WHERE Y.No = 144;
i found an error in INNER JOIN syntax..
but i have successfully displaying 2 Related table in SELECT syntax..
my question..
any other way two delete two related table like above??..,
sorry if i ask out of topic..
need help... :)