Re: Combine query views into one SQL string - Mailing list pgsql-sql

Maik wrote:
> 
> With "Union" you can create one view.
> Ciao Maik

UNION wouldn't have the desired effect:

the result of a UNION SELECT would look like this:

ID AMOUNT
1  (table1.amount)
2  (table1.amount)
.   .
.   .
1  (table2.amount)
2  (table2.amount)

What he wants is:

ID TABLE1.AMOUNT TABLE2.AMOUNT
1  (amount)      (amount)
2  (amount)      (amount)
.  .             .
.  .             .
You can achieve that result with an inner join (and even MySQL with it's
rather restricted SQL subset supports an inner join).

Nils 
-- 
Alles van waarde is weerloos
Lucebert