I would probably lean more towards using a coalsesce approach… SELECT MAIN.DATE, SUM(COALESCE(X.Gross, 0)), SUM(COALESCE(Y.Gross, 0)) FROM `MAIN_TABLE` AS MAIN LEFT JOIN `TABLE1` AS X ON MAIN.Date = X.Date LEFT JOIN `TABLE2` AS Y ON MAIN.Date = Y.Dat...