insert into one table with selects from 4 others

From: <chrisoc_at_ans.net>
Date: Fri, 12 Mar 1999 21:35:27 GMT
Message-ID: <7cc1au$3h6$1@nnrp1.dejanews.com>

I need some sample syntax doing this:

Update TableA insert (V1, V2, V3 V4)
using (select sysdate from dual V1, select sum(something) from TableB V2, select min(something) from TableC V3, select avg(something) from TableD V4)

assume the data types are 100% compatible

Thanks
I am stumbling around and cannot hit on the syntax to make SQLPlus happy.

Chris O'Connor

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 15:35:27 CST