Re: inserting multiple rows with one statement

INSERT () SELECT ();



"Cali Hotstuff"  wrote in message
news:e30679f9.0302211417.67629243@posting.google.com...
> 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