Re: Get count(*) inside SELECT

[Peter Brawley]

Is this what you mean?

SELECT 
  customerID,
  SUM( If( notr=10,1,0) ) as invCount,
  SUM( Case WHEN notr = "10" THEN t1.value Else 0 End) invoiceValue,
  SUM( Distinct If( notr=16,1,0) ) as creditCount,
  SUM(Case WHEN notr = "16" THEN t1.value Else 0 End) creditValue
FROM table
GROUP BY customerID;