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