Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » (no subject)
(no subject) [message #682643] Sat, 11 June 2011 17:56
Viacheslav Petriaiev is currently offline 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;
Previous Topic:Cascade delete not desired, on a ManyToMany relation
Next Topic:(no subject)
Goto Forum:
  


Current Time: Wed Oct 01 04:03:56 GMT 2014

Powered by FUDForum. Page generated in 0.14359 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software