Thank you,
I was definitely on the wrong track on this one.
I annotated your commands to make sure that I understood what they
were doing. Are my comments correct?
---------------
You have the wrong syntax. You can't mention a table in the WHERE
clause that wasn't in the FROM clause. Try
DELETE data FROM data JOIN sidtemp ON data.cid = sidtemp.cid;
/* deletes all records in data with cid equal cid in sidtemp but leaves
sidtemp unchanged */
or
DELETE data FROM data, sidtemp WHERE data.cid = sidtemp.cid;
/* deletes all records in data and sidtemp where cids are equal */
----------------------
/* Will the USING clause work also? */
or
/* looking that link below: */
DELETE data FROM data USING data, sidtemp WHERE data.cid =
sidtemp.cid
or
DELETE data FROM data USING data, sidtemp JOIN sidtemp ON data.cid
= sidtemp.cid
Is the above correct also?
Thank you,
raymond
------------------------------
See the manual for details
<http://dev.mysql.com/doc/refman/4.1/en/delete.html>.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
