Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » (no subject)

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

(no subject) [message #682643]

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 to get query using Criteria API 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;

Report message to a moderator

Previous Topic:	Cascade delete not desired, on a ManyToMany relation
Next Topic:	(no subject)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 09:36:49 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter