----- Original Message -----
From: "Trey Mack" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, June 08, 2007 1:08 PM
Subject: Re: [sqlite] SQL query help...
Here's what I tried, which didn't work...
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(thick) - min(thick) as diff from plypoint
where diff > 0.0005
group by zone,location
That causes a "misuse of aggregate" error.
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(thick) - min(thick) as diff from plypoint
group by zone,location
having diff > 0.0005;
Trey,
That seems to work great. I appreciate the assistance - thank you.
Jeff
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
