Tracey,
You should be able to do that as a VIEW.
Steve
Tracey Maule said:
>> >> what i was wondering is if i can do something like this without a
> stored
>> >> procedure:
>> >>
>> >> Select extract(month from incident_date) as TheDate,
>> >> //these bits are the bits i need, but cannot do
>> >> (select sum(ltiormti) where ltiormti = 'L') as LTI,
>> >> (select sum(ltiormti) where ltiormti = 'M') as MTI
>> >>
>> >> from incident
>> >> where companyid = companyid
>> >> and
>> >> ((extract(month from incident_date) >= 3 and extract(year from
>> >> incident_date) >= 2002)
>> >> or (extract(month from incident_date) < 3 and (extract (year from
>> >> incident_date) = 2003)))
>> >> order by incident_date
>> >>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
