Hello,

I am using the following HSQL query in a Spring project

select e.id, c.firstName, c.lastName, c.email, max(e.creationDate)
from Enquiry as e inner join e.theCustomer as c
group by e.id, c.firstName, c.lastName, c.email,
e creationDate.

which returns a list of java objects. Unfortunately, I am not sure
what those objects are: Enquiries, Customers, or other objects?

How can I tell?

Many thanks.

Philroc

The fact that it is an inner join is irrelevant.

The select clause tells you what objects are being returned:

select e.id, c.firstName, c.lastName, c.email, max(e.creationDate)

Each row of the result set will be an array of objects, which will be typed according to the properties you have specified in the clause above.

eg, e.id might be an Integer, c.firstName will probably be a String, etc.

HTH

Jordan.

Many thanks, gusgorman. That's exactly what I needed to know.