[DUG]: SQL Query...

[Mark Derricutt]

Is it possible to do an "insert into" query and supply a series of
values from a "select from" query?

I want to do something like:

  insert into sometable values {
    select * from someothertable where id = 2 }

???
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz