SELECT
*
FROM
Verbali
WHERE
status=1
AND pratica NOT IN (SELECT pratica FROM Verbali WHERE status=2)
Ho provato ma non funziona
Allego codice
Codice PHP:
$query = "SELECT *FROMtblverbaliWHEREPraticaConclusa = 'No'AND PraticaConclusa NOT IN (SELECT PraticaConclusa FROM tblverbali WHERE PraticaConclusa = 'Si')";