Selecting data from more than one table: I am getting exception

[Arun R. S. Chandran]

Hi everybody,

I am usin Hibernate as JDBC. I want to select datas fro two tables.
For example the field names are datavalue and reportindex. I wish to take reportindex which is a PRIMARY KEY field of table: funnelguagemain and it is a FORIEGN KEY field of table: funnelguagecontens.

The data value field content coming under funnelguagecontents table. I wish to select the report index by some condition and accoring to that reportindexes I've select datavalue from funnelguage tables.
Thes getting values shoul be store in a single list.
In that list reportindex may repeat. Imeant the reportindex field is repeating in tne table report contents.

I tried in may ways, but I couldn't reach a solution can anybody help me..
please..
Tanks
-Arun

[Paul Sturrock]

I am getting exception

And what is that exception?

[Arun R. S. Chandran]

Different times I got different exceptions.
1. Right paranthesis missing
2. single query returns more than one row.

Like that I got exceptions.

But I correct allthose exceptions and I run the query It is running and not stopping. I more thing I am not using a loop.. Then Why it is not stopping .

The Query I wrot is given below

"Select new GuageReportdata(fgrc.datavalue,fgrc.funnelguagereportmain.reportindex)
from Funnelguagereportcontents fgrc, Funnelguagereportmain fgrm where fgrm.shopnumber=?
and fgrm.guagetype=? and to_char(fgrm.datetime,'DD-mm-yyyy hh24:mi:ss') between ? and ?
and fgrm.totalpoints > 0 and fgrm.entry1=? order by fgrm.reportindex desc

"

Thanks
-Arun