> INSERT INTO <TABLE> (<FIELD LIST>)
> SELECT <FIELD LIST FOR VALUES>
> FROM <2.TABLE>
> WHERE <WHERE CLAUSE>
The WHERE clause of your example is tied to the sub-query that does the
SELECT. It is not part of the INSERT statement in your example. If you read
the MS SQL Books online and pay particular attention to the BNF
specification of the INSERT INTO query you will see that this is correct.
Paul
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
