From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: 3 SELECTs rolled into 1 ? |
Date: | 2008-06-04 07:55:46 |
Message-ID: | 20080604075546.GB24432@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Stainburn | 2008-06-04 08:44:41 | months, intervals and integers |
Previous Message | Tarlika Elisabeth Schmitz | 2008-06-04 07:41:29 | 3 SELECTs rolled into 1 ? |