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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
