-----BEGIN PGP SIGNED MESSAGE-----
I'll try to keep this short and sweet.
I'm having an issue with the insert ... select syntax. I know I
can do the following:
insert into db1.table(column) select column from
db2.table.column2 where db2.table.column1 = 'x';
which works fine. But what I also need to do is add additional
values to the INSERT portion of the statement. These values are not a
part of the select portion of the statement. I've tried the following,
to no avail:
insert into db.table1(a,b,c,d) values ('w','x', select j
from db2.table.column2 where db2.table.column1 = 'k','z');
I just want to ...