<div>
<div class="content wysiwyg-content">
Is it possible at all to include multiple fields included in crosstab query? For example in below code I now have 2 fields I need to look at as below:<br />
<br />

<pre><code id="code-10-29117851-1">SELECT
  IfNull(c.Adviser, 'GRAND TOTAL') AS Adviser,
  Sum(CASE WHEN Month(i.CompDate) = 1 THEN i.comms + i.broker_fee + i.legal_fees ELSE 0 END) Jan,</code></pre>
<br />
<br />
What I now need if possible:<br />

<pre><code id="code-10-29117851-2">Sum(CASE WHEN Month(i.CompDate) = 1 THEN i.comms ELSE 0 END) OR Sum(CASE WHEN Month(i.signedupdate) = 1 THEN i.legal_fees ELSE 0 END)  Jan,</code></pre>
<br />
<br />
Does that make any sense?
</div>
</div>


Is it possible at all to include multiple fields included in crosstab query? For example in below code I now have 2 fields I need to look at as below:

(CODE)


What I now need if possible:
(CODE)


Does that make any sense?

Include multiple fields included in crosstab query

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.