>OK Nigel ---
>
>As I understand it, let's say Table A has columns A,B,C,D and A is an identity. Table B had E,F,G,H. Since A is an identity, it should auto-increment when records are added and, therefore, shouldn't be mirrored in the select portion (this only works if B=F,C=G,D=H in structure). Then...
>
>insert into table_a (b,c,d) values (select f,g,h from table_b)
>
>This should work.
>
>
Thanks, I'll try that (when my SQL PC has finished its deleting) although I didn't think you could do it like that - the documentation says INSERT INTO tablename SELECT ... which is why I posted this thread.