Re: [GENERAL] what the problem with this query

[William Penberthy]

IT appears you have one too many closing parans…   SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, centroid ( c.the_geom )           AS the_geom, c.ogc_fid AS ogc_fid FROM ( ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname )           INNER JOIN (           SELECT orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND dataperiodid = 86 )           AS e ON o.orgunitid = e.orgunitid )           AS new_table USING UNIQUE ogc_fid USING SRID=-1   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of venu gopal Sent: Friday, April 14, 2006 5:09 AM To: pgsql-admin@postgresql.org; pgsql-general@postgresql.org Subject: [GENERAL] what the problem with this query   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_fid FROM (ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER JOIN (SELECT orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_table USING UNIQUE ogc_fid USING SRID=-1 Error::ERROR:  syntax error at or near ")" at character 333 Regards, venu