Hi the following query works in access 2010 but not SQL Server 2012. The error I am getting says 'Each GROUP BY expression must contain at least one column that is not an outer reference'. From my research it is because the query groups by a literal.
How can I achieve the same result in SQL Server

```
SELECT 
1 AS ID, Sum([Meds].TotalMeds) AS   TotalMeds, 
Sum([Meds].Presc) AS Presc 
INTO Stats_Meds
FROM 
[Meds], Rounds
WHERE 
((([Meds].Round)<[Rounds].[Round]))
GROUP BY 
1;

```

thanks