Re: Lookup between 2 files ( korn shell )

I would install Oracle 10g, define the files as external tables T1 (F1, F2) and T2 (R1, R2, R3)
and run

select t2.*
  from t2 join t1 using (t2.r2=t1.f1)

Install Oracle 10g Express - 25 minutes. Create External table definition - 10 minutes. cut 'n paste the select -

Or I culd do it the hard way - with a PERL script. <g> Received on Sat Jan 28 2006 - 00:50:28 CST