aggregate query

[JRough]

I need to do an aggregate query on the volume field. I'm really not
sure if I'm doing it right. The query2 has some filters. THANKS.

SELECT permno, name, sum(vol)
FROM myTable
WHERE permNo IN(query2)
Group BY PermNo

 

[KARL DEWEY]

Your query here does not know (query2) or what field in the query to compare
with.
Try this ---
SELECT permno, name, sum(vol)
FROM myTable, query2
WHERE permNo = [query2].[SomeFieldName]
Group BY PermNo, name

 

[JRough]

Your query here does not know (query2) or what field in the query to compare
with.
Try this ---
SELECT permno, name, sum(vol)
FROM myTable, query2
WHERE permNo = [query2].[SomeFieldName]
Group BY PermNo, name

--
KARL DEWEY
Build a little - Test a little

I need to do an aggregate query on the volume field. I'm really not
sure if I'm doing it right. The query2 has some filters. THANKS.

SELECT permno, name, sum(vol)
FROM myTable
WHERE permNo IN(query2)
Group BY PermNo

Thanks.