Re: Delete Related Table
| From: | 1LT John W. Holmes | Date: | Mon, 03 Feb 2003 14:27:29 +0000 |
| Subject: | Re: Delete Related Table | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-134112@lists.php.net to get a copy of this message | ||
> 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... :)
What database are you using? It probably doesn't support that type of query.
---John Holmes...