[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: [OT] Calling SQL gurus..
- To: <ukha_d@xxxxxxx>
- Subject: RE: [OT] Calling SQL gurus..
- From: "aashram" <groups@xxxxxxx>
- Date: Thu, 7 Aug 2003 12:46:28 +0100
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
in oracle and I suspect in standard sql
you just do this
INSERT INTO table2 (field1,field2,field3) (SELECT 'abc',value1,value2 FROM
table1 WHERE value3 = 'xyz')
-----Original Message-----
From: kinchyuk [mailto:alex@xxxxxxx]
Sent: Thu 07/08/2003 12:42
To: ukha_d@xxxxxxx
Cc:
Subject: [ukha_d] [OT] Calling SQL gurus..
Hi,
I'm trying to do a SQL insert on MS SQL 2000 that does a select query
to insert a couple of fields in the record. Something like:
SELECT value1,value2 FROM table1 WHERE value3 = 'xyz'
INSERT INTO table2 (field1,field2,field3) VALUES ('abc',(value1 from
select),(value2 from select))
Help!
Alex
Home |
Main Index |
Thread Index
|