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: [EMAIL PROTECTED] > Date: Thu, August 31, 2006 6:22 pm > To: [email protected] > > 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
