AlexG

SELECT COUNT(Transfers.Debt), SUM(Transfers.Debt), COUNT(NoSale.LDate) FROM Transfers LEFT JOIN NoSale ON Transfers.UserID = NoSale.UserID AND Transfers.UserID = Noise.UserID WHERE (Transfers.UserID=:param1 AND Transfers.LDate>=:param2 AND NoSale.UserID=:param1 AND NoSale.LDate>=:param2 AND Noise.UserID=:param1 AND Noise.LDate>=:param2)