Re: Sub-query on Calculated Field Problem

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 23 Apr 2009 14:40:03 -0300
Message-ID: <49f0a7f5$0$5501$9a566e8b_at_news.aliant.net>


DannyDarko wrote:

> I am working with a database that tracks sector scores for economic
> data. There are five sectors that are scored for geography entities. A
> scoring record is entered for each geo entity for every month. I need
> to find the highest Total Score (=Sect1Score + Sect2Score ... +
> Sect5Score) for the last 10 years for each geo entity. The problem is
> the Total Score is calculated and I can't seem to join this value back
> into the table to retrieve the records that would include the sector
> scores. If the Total Score was a field in the db then getting the
> results would be very easy, but alas not. TIA, DD

There is no theoretical reason I can see to prevent you from doing your join. If you are dealing with a limitation of your dbms, I suggest you might find better answers in a product-specific group. Received on Thu Apr 23 2009 - 19:40:03 CEST

Original text of this message