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."
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)
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)
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)
