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: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On
Behalf Of venu gopal
Sent: Friday, April 14, 2006 5:09
AM
To: pgsql-admin@xxxxxxxxxxxxxx;
pgsql-general@xxxxxxxxxxxxxx
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
