mardi 24 novembre 2015

Multiple where in clause in Mysql

When using the following query Im getting the incorrect results. How can I fix this when working with multiple where in clauses and HAVING

SELECT item
FROM Table
WHERE fld1 IN ('26','27)
AND fld2 IN ('62')
GROUP BY item
HAVING COUNT(DISTINCT fld1) = 2
AND    COUNT(DISTINCT fld2) = 1

PHPMYADMIN

enter image description here



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1lGFRhA
via IFTTT

Aucun commentaire:

Enregistrer un commentaire