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?