Selecting Field And Sum Of Field Issues Error.

With this query:
SELECT Table1.1ID, Table1.Field1, Table2.2ID, Table2.Field1, Table3.3ID, Table3.Field1, sum(Table1.Field1), sum(Table2.Field1), sum(Table3.Field1)
FROM Table1 INNER JOIN
Table2 ON Table1.1ID = Table2.2ID INNER JOIN
Table3 ON Table2.2ID = Table3.3ID

I get this error:
Column 'fieldname' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

Is it because you can't do what I'm trying above or am I missing something?

Thank you!

--PhB