Combining outputs of queries!

From: Sameer <dolpheen_at_gmail.com>
Date: 10 May 2006 07:11:03 -0700
Message-ID: <1147270263.326982.146920@e56g2000cwe.googlegroups.com>

I have outputs of several queries having two fields. These queries have one common field and an other field. The rows returned by all of them are same. For example:

Query1: CommonField, Field1
Query2: CommonField, Field2
Query3: CommonField, Field3
Query4: CommonField, Field4
Query5: CommonField, Field5

I want to combine output of these queries in one table having fields: CommonField, Field1, Field2, Field3, Field4, Field5 One way is to create views for each of these queries as View1, View2,.... View5
and then executing the statement:

select View1.CommonField, View2.Field2, View3.Field3,... View5.Field5 from View1,View2...View5.

But this is a long way which requires temporary views.

Is there any another efficient way to do this task in one command?

Please help.

-Sameer Received on Wed May 10 2006 - 09:11:03 CDT