try something like:
insert into x (colx, coly, colz)
select cola, colb, colc
from y
where ...
--
Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com
P.Silva <psilva_at_--nospam--eden.dei.uc.pt> wrote in message
news:3739b030.0_at_news.ip.pt...
> How can I select rows from one table to another with similar (but not
equal)
> structure, using SQL for Oracle 7.3?
> Under MS-SQL (arghh...) I used to use SELECT-INTO but that doesn't seems
to be
> supported on Oracle 7.3
>
> Thnaks in advance.
>
> --
> --------------------------------------------------------------------------
> ----------
> Paulo Silva
>
> http://www.criticalsoftware.com
> mailto:psilva@ criticalsoftware . com
>
>
Received on Wed May 12 1999 - 11:56:56 CDT