sum hours fields into another table

[wbower34]

Evening,

I can not figure out what I am missing on the following select statement, where the output of the select statement with sums on the two hours fields. Would like to direct it to a table created by doing a select into with only 3 pieces of data for member. Then I can join with the members detail table to compile the information.

This works, but I have not been able to get just three pieces of data to write into another table.

select "nmember", sum(volhours) as Vol, sum(advtrnghrs) as ADV
from "Naturalisthrs".naturalisttimesheet group by nmember


When I tried doing the same idea in this query, I get names but no sums for each member.

select "Lname", "Fname", sum(volhours) as Vol, sum(advtrnghrs) as ADV
from "Naturalisthrs".naturalisttimesheet as A
right outer join
"Naturalisthrs".naturalist_members as B
on a.nmember = b.abbrname
where "Status" = 'A'
group by "Fname", "Lname"
order by "Lname"


I believe I have a logic error but, have looked too long and can not find it.

thanks in advance.