Hi, I'm using:
mysql Ver 11.18 Distrib 3.23.53a, for pc-linux-gnu (i686) I did the following query succesfully SELECT * FROM staff_user LEFT OUTER JOIN staff ON SCode1 = staff_SCode WHERE SCode1 IS NULL It returned all the row that was not in the right table. Know I want them deleted, but using: DELETE FROM staff_user LEFT OUTER JOIN staff ON SCode1 = staff_SCode WHERE SCode1 IS NULL gives me an error: mysql> DELETE FROM staff_user LEFT OUTER JOIN staff ON SCode1 = staff_SCode WHERE SCode1 IS NULL; ERROR 1064: You have an error in your SQL syntax near 'LEFT OUTER JOIN staff ON SCode1 = staff_SCode WHERE SCode1 IS NULL' at line 1 what is going on here and can someone help me?????? thx Cecil Mnr Cecil J.C. Brand Internet Office RekenaarDienste University of the Free State/ Universiteit van die Vrystaat PO Box 339 Bloemfontein 9300 South Africa Tel :401 2645 Email :[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
