Re: Merge Data Sets

Hi,

without seeing much sense ...

"Andy Johnson" <AJohnson_at_Armature.com> wrote in message news:783866CAB183D211883F0090271F46C20884E0B1_at_COW...

> Hi,
> Does anyone have any experience with merging two data sets that have no
> relationship whatsoever. for example.
>
> Table X ( Acol varchar2,Bcol varchar2,dob date)
>
> Table Y (XCol Number)
>
> |
> |
>
> Table Z (XCol number, Acol varchar2,Bcol varchar2,dob date)
>
> these table have no join key and thier is around 25 million rows..
>

how about

create table z as
select t1.*,t2.* from
(select rownum a,a.* from x a) t1
,(select rownum b,b.* from y b) t2
where t1.a=t2.b

Hth
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG