SELECT dt_id, COUNT(dtr_articolo_fk)AS cnt
FROM st_documenti_testate
LEFT OUTER JOIN st_documenti_righe ON dtr_testata_fk
= dt_id
WHERE dt_chiuso
=0AND cnt = 0
GROUP BY dt_id