o.orgunitid = e.orgunitid) That ")" is not valid Venu. (Nothing is being enclosed)
Regards, Guido On 4/14/06, venu gopal <[EMAIL PROTECTED]> 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_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 > > -- Guido Barosio ----------------------- http://www.globant.com [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
