query problem with Access database

Hi,

I am writing a Java application that uses an Access database. I have
the following query that has mulitple joins and a sum on one of the
fields:

Select a.date, b.name, sum(c.score) as total
from (table1 as a,
inner join table2 as b on a.person_id = b.id)
inner join table3 as c on a.game_id = c.id
group by a.date, b.name

If I run the query in Access, it works fine, but from within the Java
code, I get the SQLException "You tried to execute a query that does
not include the specified expression 'DATE' as part of an aggregate
function."

Any help would be greatly appreciated.

Jeff

.

Relevant Pages

  • Re: Still cant solve this, multiple database query pls help.
    ... Why not have a new Access database which links the tables from both the SQL and Access database? ... or extra table etc. i can ONLY Query them. ... dbo_tForecastFF.sData FROM (((dbo_tContactPersoon INNER JOIN ... The lForecastID comes from a textbox the user fills in. ...
    (microsoft.public.vstudio.development)
  • Re: query problem with Access database
    ... I am writing a Java application that uses an Access database. ... inner join table2 as b on a.person_id = b.id) ... If I run the query in Access, it works fine, but from within the Java ...
    (comp.lang.java.programmer)
  • Aggregate function error with Access database
    ... I am writing a Java application that uses an Access database. ... inner join table2 as b on a.person_id = b.id) ... If I run the query in Access, it works fine, but from within the Java ...
    (comp.lang.java.databases)
  • Re: query problem with Access database
    ... I am writing a Java application that uses an Access database. ... inner join table2 as b on a.person_id = b.id) ... If I run the query in Access, it works fine, but from within the Java ...
    (comp.lang.java.programmer)
  • question about scrollable resultsets
    ... I am making a small program in Java for working with an Access database ... Field=Value" and using the resultset from that query. ...
    (comp.lang.java.help)