[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: subQueries in SELECT
From:       Jakob Braeuchi <jbraeuchi () gmx ! ch>
Date:       2005-09-27 19:46:30
Message-ID: 4339A196.6090808 () gmx ! ch
[Download RAW message or body]

hi sergey,

please have a look at the subquery-testcases in 
org.apache.ojb.broker.QueryTest.

jakob

Manukyan, Sergey schrieb:
> Folks,
> 
> Can I represent in OJB this SQL statement:
> 
> SELECT C.cust_id, (SELECT count(*) FROM purchases P WHERE P.cust_id =
> C.cust_id)
> 
> FROM customer C
> 
> ?
> 
> It looks like this kind of SQL is much faster then when using SELECTS
> with GROUP BY and I would like to express it in OJB but didn't find how
> in documentation,
> 
> Thank you,
> 
> Sergey
> 
> 
> **********************
> ** LEGAL DISCLAIMER **
> **********************
> 
> This E-mail message and any attachments may contain
> 
> legally privileged, confidential or proprietary
> 
> information. If you are not the intended recipient(s),
> or the employee or agent responsible for delivery of
> 
> this message to the intended recipient(s), you are
> 
> hereby notified that any dissemination, distribution
> 
> or copying of this E-mail message is strictly
> 
> prohibited. If you have received this message in
> 
> error, please immediately notify the sender and
> 
> delete this E-mail message from your computer.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]