I'm using 3.23.37, and I am taking a random subset of records from a table, and putting them into another table: insert into targettable select * from sourcetable;
I then want to delete these records from the source table. I have tried various permutations of: delete from sourcetable select * from sourcetable,targettable where sourcetable.id=targettable.id; but with no luck. The archive only seems to have questions relating to multi-table deletes in v4, and there is nothing about this in the manual or in Carsten's FAQ. Is there a way of doing this? TIA Kevin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php