hi , i have two tables in mysql
#messages table :
messageid
messagetitle
.
.
#usersmessages table
usersmessageid
messageid
userid
.
.
now i want to delete from messages table it's ok . but when i delete message with messageid='1' for example it's still exists on usersmessage i have to delete from this two tables at once ;
so i use the following query :
DELTE FROM messages LEFT JOIN usersmessages USING(messageid) WHERE messageid='1' ;
then i test
DELETE FROM messages , usersmessages
WHERE messages.messageid = usersmessages.messageid
and messageid='1' ;
but this two queries is not accoumplish this task .