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]

Reply via email to