Hi, ist es möglich in einem MySQL case and "Filterungen" einzusetzen?
1 | select
|
2 | case COUNT(DISTINCT ti.error)when and ti.revise='F' and ti.state='A'and ti.date='L' END AS failed, |
3 | case COUNT(DISTINCT ti.sub_error)when and ti.revisen='K'' END AS sub_error |
4 | |
5 | from users u |
6 | join ... |
7 | left join ... |
8 | where u.id = 123456 |
9 | ;
|