[Cialug] SQL Question: Advanced INSERT INTO

[Todd Walton]

On Fri, Sep 3, 2010 at 2:34 PM, Todd Walton <tdwalton at gmail.com> wrote:
> insert into directory values
> (select (select top 1 directory_id from directory
> order by directory_id desc) + 1,'other columns')

I understand that there's an INSERT INTO ... SELECT type statement.
But my other columns aren't being pulled from a select statement.  For
those I have values I want to plug in.

--
Todd