Hey,

I'm working on this project where I need to copy records between different tables.

I'm making this app which moderates comments, so when a user submits a comment, it appears on a list which allows me to accept comments or reject them. I got the reject bit sorted, it requires a DROP for the relevant row.

I'm trying to make a button which accepts the pending requests to the actual visible comments, which takes the items in the pending table to be copied over to the table containing the actual comments.

I found a few solutions for this elsewhere, but they are for copying between tables with the same table structure. What is the query to copy between tables with different structures (only copy the data which is stored in similar rows in both tables)

Much appreciated,

Ian.