Using Insert with subquery or single line statement?

[Bruce D]

In theory this is what I would like to do...but I get an error:
insert into users (homeid,carid) values(1, select carid from table2 where
field=x);
Since this doesn't work...I was wondering if I can use something like
this...but I want it to be one line (I'm using ADO).
select carid from table2 where field=x into var; insert into users
(homeid,carid) values(1,var);

Any ideas?

-bruce

[Bruce D]

Got it:

insert into users (homeid,carid) select 1,carid from table2 where field=x;

That wasn't so bad!

-bruce
"Bruce D" <br*************@hotmail.com> wrote in message
news:11*************@corp.supernews.com...

In theory this is what I would like to do...but I get an error:
insert into users (homeid,carid) values(1, select carid from table2 where field=x);
Since this doesn't work...I was wondering if I can use something like
this...but I want it to be one line (I'm using ADO).
select carid from table2 where field=x into var; insert into users
(homeid,carid) values(1,var);

Any ideas?

-bruce

[Chris Hope]

Bruce D wrote:

In theory this is what I would like to do...but I get an error:
insert into users (homeid,carid) values(1, select carid from table2
where
field=x);
Since this doesn't work...I was wondering if I can use something like
this...but I want it to be one line (I'm using ADO).
select carid from table2 where field=x into var; insert into users
(homeid,carid) values(1,var);

How about this:

insert into users (homeid,carid)
select 1, carid from table2 where field=x

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/