The error message doesn't seem to match your SQL...
It only shows up to 'AND tblTest.URL = tblT' but your SQL is 'AND tblTest.Comment = tblTest2.Comment'
Is that a problem??
An example from MySQL manual is 'DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id'
Leo
Bamelis Steve wrote:
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
