On Tue, Dec 07, 1999 at 09:14:37PM -0500, Joseph Shraibman wrote:
> INSERT INTO application (key, creator, name) values ( 1 ,(select userkey
> from
> user where username = 'b' ), 'newapplication') ;
INSERT INTO application (key, creator, name) SELECT 1, userkey,
'newapplication' from user where username = 'b';
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(at)Fam-Meskes(dot)De | Use PostgreSQL!