Scalar query and objects instances

didoudao · **Joined:** Mon Nov 17, 2003 11:44 am **Posts:** 6

Hye,

We have a scalar query like SELECT DISTINCT A.NAME, A.YEAR, B.CAR ... FROM TABLEA A, TABLEB B ...

Is there a way to retrieve the objets A, B ... in the result.

(In the reality, the query is more complex i.e several tables and a lot of where clauses)

Thank's

christian · **Posted:** Fri Nov 21, 2003 9:10 am

didoudao · **Joined:** Mon Nov 17, 2003 11:44 am **Posts:** 6

Hye, chris !

You said Yes but how ?

Thank's

christian · **Posted:** Fri Nov 21, 2003 9:18 am

http://www.hibernate.org/hib_docs/refer ... anguage-s4

didoudao · **Joined:** Mon Nov 17, 2003 11:44 am **Posts:** 6

Thank's chris, but it's a little bit more complicated.

Our query use 'DISTINCT' to evict duplicate rows, but if we use SELECT DISTINCTA, B ... in place of SELECT DISTINCT A.NAME, A.YEAR, B.CAR ... the query returns duplicate rows.

I hope you'll undertand what i mean !

Thank's

christian · **Posted:** Fri Nov 21, 2003 9:44 am

Hm, it shouldn't. Gavin?

gavin · **Posted:** Fri Nov 21, 2003 9:51 am

well, if there are multiple rows with the same data, but different ids then yes, this would happen - of course.