I'm currently using the following query:
SELECT SUM(IF(`01`=1, 1,0)) AS 01A, SUM(IF(`01`=2, 2, 0)) AS 01B..., SUM(IF(`55`=1, 1,0)) AS 55A, SUM(IF(`55`=2, 1,0)) AS 55B FROM tableA INNER JOIN tableB ON tableA_ID = tableB_ID INNER JOIN tableCON tableB_aID = tableC_aID INNER JOIN tableD ON tableD_ID =tableC_ID INNER JOIN tableE ON tableD_ID = tableE_ID GROUP BY tableA_ID
The result has to the following. There mutiple rows of tableA_ID, if one of the fields 01 in this set has a 0 the result of the group by has to be 0. If one of the result has no 0 but a 1, the result of the group by has to be 1 and finally if there is a 2 in the result, the group by has to be a 2.
I'm currently using the query as showned above, and another query to examing the results of above the get the right value. But there has to be a more efficient way (I hope). Can anybody here show me the better way.
TIA
AC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
