On Wed, 4 Jun 2008 09:55:46 +0200 "A. Kretschmer" <[EMAIL PROTECTED]> 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? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
