On Wed, 4 Jun 2008 09:55:46 +0200
"A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote:
> 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
> > FROM item
> > LEFT JOIN product ON ...
> > LEFT JOIN department ON ...
> > LEFT JOIN section ON ...
> > LEFT JOIN category 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.
Many thanks!
Yes, this produces the desired result.
It is more or less just a concatenation of virtually identical SELECTs
with the same long WHERE clause. I had hoped to be able to express it
with a single SELECT. ;-)
--
Best Regards,
Tarlika Elisabeth Schmitz
A: Because it breaks the logical sequence of discussion
Q: Why is top posting bad?