Re: 3 SELECTs rolled into 1 ?

am  Wed, dem 04.06.2008, um  8:41:29 +0100 mailte Tarlika Elisabeth Schmitz folgendes:
> I have 3 similar SELECTs. I am wondering whether they could be rolled
> into one?
> 
> 
> SELECT
>  item.id 
>  department.id || section.id || category.id as x

Syntax error, missing , between the columns ;-)



> FROM item
>  LEFT JOIN product ON ...
>  LEFT JOIN department ON ...
>  LEFT JOIN section ON ...
>  LEFT JOIN category ON ...
> 
> SELECT
>  item.id 
>  department.id || section.id as x
> FROM item
>  LEFT JOIN product ON ...
>  LEFT JOIN department ON ...
>  LEFT JOIN section ON ...
> 
> SELECT
>  item.id 
>  department.id as x
> FROM item
>  LEFT JOIN product ON ...
>  LEFT JOIN department ON ...


If i understand you correctly: use UNION, like 

select foo1 as foo, bar1 as bar from table1 UNION ALL select foo2, bar2 from table2;

The result table contains 2 columns foo and bar and all rows from both
selects.

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net