Basically, I want to create a system where I am archiving data -
copying it from the active tables to the archive tables.
I am setting this up so that any user can do it, not just someone
technical like me.
I am wondering if there is a way to copy multiple data sets with
conditions into multiple data tables without doing a loop. Something
INSERT INTO archive_a, archive_b SELECT * FROM a, b WHERE b.lid = 10
AND a.tid = b.tid
Though this doesn't really work. 'tid' and 'lid' are just identifiers
to match up the data ...