Re: [PHP] Delete Related Table

2003-02-03 Thread 1LT John W. Holmes
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

[PHP] Delete Related Table

2003-02-02 Thread Remon Redika
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