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 || 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 ... -- 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