Strange. That’s the type of query I was trying that failed. Hence this GQ. But cutting and pasting your suggestion into the SQL box worked. I must’ve got my own sql wrong. (I’m usually pretty good at getting my sql right first time)
I was using MySQL. but friedo’s reply fixed the problem. I guess there must have been a slight error in my code. I think I was trying to do this…
INSERT INTO imagestable (filename) values SELECT filename FROM pending;