need query help?
SQL> desc tablebee
Name Null?Type
-- -- -
DEPID NOT NULL NUMBER
DEPNAMEVARCHAR2(10)
SQL> desc tableaa
Name Null?Type
-- -- -
NAME NOT NULL VARCHAR2(10)
ADEPID NUMBER
AADEPIDNUMBER
SQL> select * from tablebee;
DEPID DEPNAME
- -
99 siva
100 ram
900 classa
901 classb
SQL> select * from tableaa
2 ;
NAMEADEPIDAADEPID
- - -
the hindu 99900
express100901
i want output
-
thehindu siva classa
how to write query for this?
[607 byte] By [sivakaminathana] at [2007-11-27 4:24:50] 