Insert blocks of data into a table

From: Alan <alanpltse_at_yahoo.com.au>
Date: Tue, 11 Sep 2001 12:18:01 +1000
Message-ID: <9njsfg$7j9$1_at_merki.connect.com.au>



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 Tue Sep 11 2001 - 04:18:01 CEST

Original text of this message