Sybase - Useful sqls

1. Copy records from table A to table B

insert into tableA

select * from table B where {conditions}