Unfortunately, nope. This is simple aggregation. The stuff I need to do is compounded aggregation (see earlier post).
> I think as Mark pointed out you can do this sort of thing in another way: > SELECT m.ID, sum(a.SomethingValue) > FROM MainTable AS m, AnotherTable AS a > WHERE m.ID =3D a.ID > GROUP BY m.ID > And is probably much faster > (unless I've missed the point or you can't do it in MySQL?) > What I'm interested in is there anything anyone can think of that can't = > be done another way? > Curious, > - James > > -----Original Message----- > From: Gary Menzel [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 15, 2004 3:15 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Aggregated reports (related to : QofQ from > different-datasources) > > > > Subselects ? > >=20 > > Can they do anything useful which Selects cannot ? > > > Sub-selects allow you to execute other SELECTS in one query that are the = > > result of executing another query (sort of looping over loops). > > So you can say things like: > > SELECT > ID, > ( > SELECT > Sum(SomethingValue) > FROM > AnotherTable AS a > WHERE > a.ID =3D m.ID > ) as SumOfSomethingValue > FROM > MainTable AS m > WHERE > AField =3D 'Some Value' > > The above could SUM all the SomethingValue's in the child table for the=20 > nominated ID of the current record in the outer SELECT (ie. give you the = > > SUM of child records for each of the parent records). > > > > Gary Menzel > Web Development Manager > IT Operations Brisbane -+- ABN AMRO Morgans Limited > Level 29, 123 Eagle Street BRISBANE QLD 4000 > PH: 07 333 44 828 FX: 07 3834 0828 > > > > If this communication is not intended for you and you are not an = > authorised recipient of this email you are prohibited by law from = > dealing with or relying on the email or any file attachments. This = > prohibition includes reading, printing, copying, re-transmitting, = > disseminating, storing or in any other way dealing or acting in reliance = > on the information. If you have received this email in error, we = > request you contact ABN AMRO Morgans Limited immediately by returning = > the email to [EMAIL PROTECTED] and destroy the original. We = > will refund any reasonable costs associated with notifying ABN AMRO = > Morgans. This email is confidential and may contain privileged client = > information. ABN AMRO Morgans has taken reasonable steps to ensure the = > accuracy and integrity of all its communications, including electronic = > communications, but accepts no liability for materials transmitted. = > Materials may also be transmitted without the knowledge of ABN AMRO = > Morgans. ABN AMRO Morgans Limited its directors and employees do not = > accept liability for the results of any actions taken or not on the = > basis of the information in this report. ABN AMRO Morgans Limited and = > its associates hold or may hold securities in the companies/trusts = > mentioned herein. Any recommendation is made on the basis of our = > research of the investment and may not suit the specific requirements of = > clients. Assessments of suitability to an individual?s portfolio can = > only be made after an examination of the particular client?s = > investments, financial circumstances and requirements. > > > --- > You are currently subscribed to cfaussie as: = > [EMAIL PROTECTED] > To unsubscribe send a blank email to = > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
