not able to execute query on spatial database.

Hello all,<br />            I am working with spatial tables. i have two spatial data tables, one represents the whole
stateand another table represents the damaged locations in the state. My aim is to find number of damaged locations in
everycounty or parish.<br /> Here i am giving the query i used to do this, could you please tell me whether i am doing
rightthing or not.<br /><br /><span style="font-weight: bold;">select count(*) from damagedlocations l1,county l2 where
(l2.the_geomand l1.the_geom) and l2.parishid=particular_parishid;<br /><span style="font-weight: bold;"><br /><span
style="font-weight:bold;"></span></span></span>thanks in advance.<br /> vamsee movva<span style="font-weight:
bold;"><spanstyle="font-weight: bold;"><span style="font-weight: bold;"></span><br /></span></span>