Hi, I'm a newbie when it comes to mySQL.
I have the following command. DELETE FROM tblTest2 USING tblTest2,tblTest WHERE tblTest.Name = tblTest2.Name AND tblTest.URL = tblTest2.URL AND tblTest.Comment = tblTest2.Comment I get the following error: You have an error in your SQL syntax near 'USING tblTest2,tblTest WHERE tblTest.Name = tblTest2.Name AND tblTest.URL = tblT' at line 1 I want to delete rows from tblTest2 where there are similarities in tblTest. In fact using a subselect or something. Could anyone help me please, Thx