Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » (no subject)

Sat, 11 June 2011 13:56

Eclipse User

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;

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 05:33:29 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter