ptting values from another table

[Cool]

Hi how i can put these values from another table

Code Select Expand

                    query = QuerySQL( sqliteDB, "INSERT INTO Banned( ban_nick, ban_ip, ban_time, ban_expire, ban_expireratio, ban_admin, ban_reason, ban_uid, ban_uid2 ) VALUES ( '"+ player.Name.tostring() +"','"+ player.IP.tostring() +"','"+ time().tostring() +"', '"+ ban_Expires.tostring() +"', '" + expire.tostring() + "', '"+ admin.Name.tostring() +"', '"+ reason.tostring() +"', '"+ player.UID.tostring() +"', '"+ player.UID2.tostring() +"')");


[.]

3 seconds with Google:

Code Select Expand

insert into table2 (name, address) select name, address from table1
http://stackoverflow.com/questions/1559789/how-to-copy-data-between-two-tables-in-sqlite