Re: what the problem with this query

On Fri, Apr 14, 2006 at 11:09:16AM +0000, venu gopal wrote:
> Hi all,
>    When i try to run the following query it gives the following error what was wrong in the query.
>
> Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, centroid(c.the_geom) AS the_geom, c.ogc_fid AS
ogc_fidFROM (ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER JOIN (SELECT orgunitid,
entrynumberFROM routinedataou4 WHERE dataelementid=1195 AND dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS
new_tableUSING UNIQUE ogc_fid USING SRID=-1 
>
> Error::ERROR:  syntax error at or near ")" at character 333

Extra ) after the the last ON.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461