Re: inserting multiple rows with one statement

INSERT () SELECT ();

"Cali Hotstuff" <calihotstuff(at)hotmail(dot)com> wrote in message
news:e30679f9(dot)0302211417(dot)67629243(at)posting(dot)google(dot)com(dot)(dot)(dot)
> I know that this is easy to do in a programming language or with a
> script, but is there any way -- purely in SQL -- to insert multiple
> rows based on the results of a subquery.
>
> ie, if SubQuery yields rows {x,y,z}, I want to somehow insert these
> three different rows into MyTable on the same query.
>
> Thanks in advance,
> cali