inner join

[jjrmy1]

need some help with some sql I can't seem to get the syntax right. I've tried several but to no avail the one below gets me the
closest but I can't get the guardians records pulled.

SELECT SUM(tuition)
FROM child INNER JOIN guardian ON guardian.ID = child.child_ID

I would like the results to show the records from the guardian table as well

tables:
GUARDIAN
fields:
ID
guardian1_first
guardian1_last

CHILD
fields:
ID
child_ID
first_name
last_name
tuition

relationship: guardian.ID = child.child_ID

results should show:

guardian1_first, guardian1_last, and the SUM(child.tuition) for all children where the child_ID is equal to the ID of guardian
listed

any help would be much appreciated, I've been driving myself mad with this

[cgsj_usa@yahoo.com]

All you have to do is include the columns in the select statement, like below.

select guardian1_first, guardian1_last, and the SUM(child.tuition)
from guardian inner join child
on guardian.id = child.childid
group by guardian1_last, guardian1_first

You will have to include a group by statement, as I did above, since there is
an aggregate function in the select statement.

Hope that this helps. Thanks.

Chris