Eclipse Community Forums: EclipseLink » How can I get count of distinct left join subquery?

Help

Home

Home » Eclipse Projects » EclipseLink » How can I get count of distinct left join subquery?

Show: Today's Messages :: Show Polls :: Message Navigator

How can I get count of distinct left join subquery? [message #682634]

Sat, 11 June 2011 17:56

Viacheslav Petriaiev

Messages: 2
Registered: June 2011

Junior Member

How can I get count records of subquery with distinct and joins?

Is it possible using Criteria API to get SQL-query like that?
select count(g.*) from (select distinct from TABLE0 t0 LEFT OUTER JOIN TABLE1 t1 ON (t1.TABLE0_ID = t0.ID)) g;

[Updated on: Sat, 11 June 2011 18:04]

Report message to a moderator

Re: How can I get count of distinct left join subquery? [message #683428 is a reply to message #682634]

Mon, 13 June 2011 17:52

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

What is the object model?

In general JPQL and Criteria do not support subselects in the from clause.

For a specific SQL query you can use a native query.

James : Wiki : Book : Blog : Twitter

Report message to a moderator