SELECT sales.RSMID, rsm.FName, rsm.LName, sales.ID AS SalesID, sales.DateSold, sales.CustName, sales.SysConfig, host.HostName, salestype.SaleType, sales.Amount, (Select Sum(B.Amount) From Sales B Where B.RSMID=Sales.RSMID AND Month(B.DateSold)=1) AS MTD, sales.Margin, rsm.Goal
FROM ((rsm INNER...