Re: Aggregation query in Oracle

bhaskarjain_at_gmail.com wrote:
> have four queries Test, Test1, Test2, Test4 all of them having same
> number of columns and same datatype
>
>
> Test results in following columns
> Refrence_Num
> First_Name
>
>
> Test1 results in following columns
> Refrence_Num
> Middle_Name
>
>
> Test2 results in following columns
> Refrence_Num
> Last_Name
>
>
> Test3 reults in following columns
> Refrence_Num
> Nationality
>
>
> I have to join these four queries in such a way that I get following
> columns in the result and for Refrence_Num I have only one row having
> all the data.
>
>
> Refrence_Num
> First_Name
> Middle_Name
> Last_Name
> Nationality
>
>
> I don't want to create a temporary table or PL/SQL for this

Why would anyone, in Oracle, create a temporary table for anything?

The question you are asking requires just the most basic of SQL skills related to joining tables.
Go to www.psoug.org.
click on Morgan's Library
click on Joins

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)