help query

[sspintux]

io c'ero

io pure ... ma dormivo

SELECT tb_tab1.*, SUM(tb_tab2.ordinato) as totale 
FROM tb_tab1 LEFT JOIN tb_tab2 ON tb_tab1.id = tb_tab2.id_tab1 
WHERE tb_tab2.id_attivo='1'  OR tb_tab2.id IS NULL
GROUP BY tb_tab1.id