hi sergey,
this looks like a report query to me. do you have relationships defined
between A, B, C, D ?
jakob
Manukyan, Sergey schrieb:
Folks,
Could you please advice an OJB solution for this SQL query:
SELECT
A.F,
(SELECT COUNT(*) FROM B INNER JOIN A ON A.F = B.F),
(SELECT AVG(C.FF) FROM C INNER JOIN A ON A.F = C.F),
(SELECT MAX(D.FFF) FROM D INNER JOIN A ON A.F = D.F)
FROM
A
The OJB subqueries mechanism doesn't work in this case or... am I
missing anything?
-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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]