Hi..<BR><BR>How do I get data from one table to another? What's the syntax like? Both tables are under the same SQL database.<BR><BR>eg. There's 7 fields in table 1, and I need 4 of these (of all records) to be copied into table 2.<BR><BR>Would appreciate any help please. Thank you in advance.