I have 3 similar SELECTs. I am wondering whether they could be rolled
into one?
SELECTitem.id department.id || section.id || category.id as x
FROM itemLEFT JOIN product ON ...LEFT JOIN department ON ...LEFT JOIN section ON ...LEFT JOIN category ON ...
SELECTitem.id department.id || section.id as x
FROM itemLEFT JOIN product ON ...LEFT JOIN department ON ...LEFT JOIN section ON ...
SELECTitem.id department.id as x
FROM itemLEFT 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?