[sqlite] Copying Records from one table to another

[jose isaias cabrera]

Greetings.
I searched the mail archive and I can not find something related to this.  I 
know it is easy, but...

What I need is to copy a record from one Table1 to Table2 of the same DB.  I 
tried,

insert into LSOpenJobs select * where id = 530 from LSOpenSubProjects;

I would like to copy the whole record.

Any help would be greatly appreciated.

thanks,

josé




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------