Copying data to another table

[SelbyGlenn]

Hi there,

Apologies if this is blatantly obvious - still very new to SQL.

How do I copy the contents of a row from one table to another table.


Thanks in advance!



Glenn
BEng MCSE CCA

 

[PHV]

Have a look to the INSERT INTO instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SelbyGlenn]

Will do.

Thanks!

Glenn
BEng MCSE CCA