copying data from table one to table two

[Siddharth Rout]

There are two tables with the same fields say 'firstname' and 'secondname'.

How do I copy all the records from the first table(tableone.mdb) to the second table(tabletwo.mdb) which satisfy the condition that the second name should be 'smith'????