RE: solution for subqueries returning values

2006-02-01 Thread Manukyan, Sergey
, qD } ) Is this functionality is planned in the roadmap of OJB? -Sergey -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 31, 2006 3:53 PM To: OJB Users List Subject: Re: solution for subqueries returning values hi sergey, this looks like

Re: solution for subqueries returning values

2006-01-31 Thread Jakob Braeuchi
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),