Hello

Why the Insert statement missing the where clause.

I mean something like:

INSERT INTO <TableName>
[(<ColumnName> [,<ColumnName>])]
VALUES (<Value> [,<Value>])|
[WHERE <FilterCondition>]
<QueryExpression>

Thanks
Sorin

Sorin,

<< Why the Insert statement missing the where clause.  >>

INSERT statements don't have a WHERE clause.

Are you thinking of:

INSERT INTO MyTable SELECT...WHERE..

?

--
Tim Young
Elevate Software
www.elevatesoft.com