[Cialug] SQL Question: Advanced INSERT INTO
tdwalton at gmail.com
Fri Sep 3 14:41:43 CDT 2010
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.
More information about the Cialug