Easy SQL question.

I am SQL stupid and I need some quick help. I need to take all the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9956-easy-sql-question.html
information from one table and insert it into another table for
archiving. The tables have identical structures but have different
functions.

This is what I am trying to do:

SELECT * INTO tblmaterials FROM tblTempList

or

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9956
INSERT INTO tblMaterials VALUES tblTempList.*

or something like that.

I just need to take all of the materials from the temp list and add to
an established archive table. Thanks for any help.


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Try

INSERT INTO tblmaterials
SELECT tblTempList.*
FROM tblTempList

--
Good Luck
BS"D


"Glen" wrote:

> I am SQL stupid and I need some quick help. I need to take all the
> information from one table and insert it into another table for
> archiving. The tables have identical structures but have different
> functions.
>
> This is what I am trying to do:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9956
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9956
>
> SELECT * INTO tblmaterials FROM tblTempList
>
> or
>
> INSERT INTO tblMaterials VALUES tblTempList.*
>
> or something like that.
>
> I just need to take all of the materials from the temp list and add to
> an established archive table. Thanks for any help.
>
>

Thanks a lot Ofer. You rock!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9956