Re: SELECT statement with multiple WHERE conditions

[Peter Brawley]

> we are unfortunately stuck with this approach and have to deal with it somehow.

You've no input into the design, but you must write complex queries for what should be simple sql tasks. Sticking anybody with such a waste of time advertises incompetence. I suppose sending that feedback up the chain puts your job at risk. Just out of curiosity, is this in the private or public sector?

If you are indeed stuck with it, you're going to need to get up to speed with pivot tables, that is with combining aggregation with Case expressions to turn EAV rows into query result columns, eg see ...

http://stackoverflow.com/questions/21836757/join-pivot-items-with-eav-table

and "Pivot tables" at http://www.artfulsoftware.com/infotree/mysqltips.php