You seem to have a dangling aggregate function in your SELECT: SELECT exposed_time, ROUND(COUNT(ses_tx_20130805.pid)/10) ***COUNT*** FROM tx_demography_info JOIN ses_tx_20130805 ON (tx_demography_info.pid=ses_tx_20130805.pid) WHERE countyid='50015' GROUP BY exposed_time ORDER BY exposed_time;
On Fri, Apr 4, 2014 at 1:25 PM, saquib khan <skhan...@gmail.com> wrote: > Thanks Decimus. > > Query: > SELECT exposed_time, ROUND(COUNT(ses_tx_20130805.pid)/10) COUNT FROM > tx_demography_info join ses_tx_20130805 on > (tx_demography_info.pid=ses_tx_20130805.pid) where countyid='50015' GROUP > BY exposed_time ORDER BY exposed_time; > > > > > > > > > On Fri, Apr 4, 2014 at 4:22 PM, Decimus Phostle > <decimusphos...@gmail.com>wrote: > >> It might help if you post details on the queries themselves. >> >> >> On Fri, Apr 4, 2014 at 1:14 PM, saquib khan <skhan...@gmail.com> wrote: >> >>> I get java exceptions while running the queries: >>> >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> java.lang.InstantiationException: org.antlr.runtime.CommonToken >>> Continuing ... >>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new(); >>> Continuing ... >>> >>> >>> >>> On Fri, Apr 4, 2014 at 4:03 PM, saquib khan <skhan...@gmail.com> wrote: >>> >>>> Dear Folks, >>>> >>>> Whenever I run join queries, it does not display the output, thought it >>>> give me output for queries on single table. >>>> >>>> Thanks and Regards, >>>> Saky >>>> >>> >>> >> >
