problem in retrieving data

[heshan]

Hi, i have a transaction table which includes following fields.

 

    tran_ID,account_number,account_type,transaction_type,amount,Date

 

I want to know how these data can be retrieved and display in another table. The table is filled with several records.

 

Thanks,

Heshan

[RussellReal]

what do you mean.. insert the rows from that table to another one?

 

INSERT INTO otherTable SELECT fieldname1 as field1, fieldname2 As field2 FROM transactionalTable WHERE id > 10;