joining shp dbf

[siva]

i try below not working


DATA "SELECT * FROM 'c:/pradesh/state.shp' LEFT JOIN 'c:/pradesh/pop.dbf' ON 'c:/pradesh/state.shp'.name = 'c:/pradesh/pop.dbf'.name"

DATA "SELECT * FROM 'state.shp' LEFT JOIN 'pop.dbf' ON 'state.shp'.name = 'pop.dbf'.name"


DATA "SELECT * FROM state LEFT JOIN 'c:/pradesh/pop.dbf'.pop ON state.name = pop.name"

i then try dbf as csv
sincerely
sshekar

> -------- Original Message --------
> Subject: [UMN_MAPSERVER-USERS] joining shp dbf
> From: volunteer at spatiallink.org
> Date: Thu, August 31, 2006 6:22 pm
> To: MAPSERVER-USERS at LISTS.UMN.EDU
> 
> hello i get probelm joining shp dbf. old answer not working
> 
> c:/pradesh/state.shp
> num name
> 1   andhra
> 2   kerala
> 
> c:/pradesh/pop.dbf
> num name   count  year
> 1   andhra 35     1991
> 2   andhra 45     2001
> 
> i try showing 45 on state.shp as following 
> MAP
> 
> SHAPEPATH "/pradesh/"
> 
> LAYER
> CONNECTIONTYPE ogr
> CONNECTION "c:/pradesh/state.shp"
> DATA "SELECT * FROM 'c:/pradesh/state.shp'.state LEFT JOIN
> 'c:/pradesh/pop.dbf'.pop ON state.name = pop.name WHERE pop.year LIKE
> '2001'"
> LABELITEM "join.count"
> 
> many thank yous
> sincerely
> sshekar