Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!paloalto-snf1.gtei.net!news.gtei.net!news.compaq.com!news.cpqcorp.net!not-for-mail From: "Narayana Vyas Kondreddi" Newsgroups: comp.databases.theory References: <9njsfg$7j9$1@merki.connect.com.au> Subject: Re: Insert blocks of data into a table Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Message-ID: Date: Mon, 24 Sep 2001 11:51:09 +0530 NNTP-Posting-Host: 16.138.246.48 X-Complaints-To: abuse@Compaq.com X-Trace: news.cpqcorp.net 1001312221 16.138.246.48 (Sun, 23 Sep 2001 23:17:01 PDT) NNTP-Posting-Date: Sun, 23 Sep 2001 23:17:01 PDT Organization: Compaq Computer Corporation Xref: easynews comp.databases.theory:18439 X-Received-Date: Mon, 24 Sep 2001 02:07:53 MST (news.easynews.com) Yes you can, as long as the table DDL of Table1 and Table2 are same, otherwise you will have to include a column list in INSERT and SELECT statements. -- HTH, Vyas SQL Server FAQ, articles, code samples, best practices, interview questions and much more @ http://vyaskn.tripod.com/ Alan wrote in message news:9njsfg$7j9$1@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 > >