Re: [SQL] 3 SELECTs rolled into 1 ?

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, > > de

Re: [SQL] 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 ;-)

[SQL] 3 SELECTs rolled into 1 ?

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