Insert blocks of data into a table

Can I use the following command:

Insert into Table1
Select * from Table2 where Table2.Field1 = '123'

Note: the select statement return more than 1 row Received on Mon Sep 10 2001 - 21:18:01 CDT