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 PetriaievFriend
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:How can I get count of distinct left join subquery?
Next Topic:Lob field fetch=FetchType.LAZY being ignored
Goto Forum:

Current Time: Fri Dec 15 08:21:11 GMT 2017

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

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