Home » SQL & PL/SQL » SQL & PL/SQL » Matching colums of two tables in oracle
Matching colums of two tables in oracle [message #2222] Fri, 28 June 2002 21:46 Go to next message
Rajneesh
Messages: 1
Registered: June 2002
Junior Member
I would like to compair columns of two tables
any body suggest me how can i do this
Re: Matching colums of two tables in oracle [message #2223 is a reply to message #2222] Sat, 29 June 2002 08:03 Go to previous message
shaheena
Messages: 17
Registered: February 2002
Junior Member
hello,
it is very simple you can do this by using nonequi join
e.g

select e.sal from emp e,salgrade s
where e.sal between s.losal and s.hisal;
you can define as many conditions as you want.
regards.
shaheena.
Previous Topic: Wat is the best UTL_FILE or sql Loader ?
Next Topic: Integer/NUmeric
Goto Forum:
  


Current Time: Thu Mar 28 11:41:15 CDT 2024