I would like to check if my sql statement is correct because I couldn't use the software to verify.

 

Table name: Comments

 

comm_id Comments vis_id comments_date news_id

1 Lousy man 67 12/12/2009 3

3 Liverpool 33 03/12/2009 3

5 abcdefgh 19 12/12/2010 1

 

Table name: Visitor

 

vis_id vis_name

9 vistor1

33 stanley

67 Arnold

 

I would like to know how to

 

Delete from visitor and comments where the vis_id = "67"

 

My sql is :

 

DELETE FROM comments, Visitor

 

WHERE Comments.vis_id = '67'

 

AND

Visitor.vis_id = '67'

 

Hope someone can tell me if my sql is correct or not.

 

Thanks.

changing the AND to OR should do it

changing the AND to OR should do it

 

Thank you very much.