Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: what the problem with this query
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: venu gopal <gopalonline2(at)yahoo(dot)co(dot)uk>
- Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
- Subject: Re: what the problem with this query
- Date: Thu, 20 Apr 2006 20:31:22 -0500
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_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 Extra ) after the the last ON. -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- References:
- what the problem with this query
- From: venu gopal
- what the problem with this query
- Prev by Date: Re: Problem with SELECT FOR UPDATE NOWAIT
- Next by Date: Re: Slony1 or DRBD for replication ?
- Previous by thread: Re: [GENERAL] what the problem with this query
- Next by thread: Slony1 or DRBD for replication ?
- Indexes: