[postgis-users] Query Help

[chris brisendine]

I am trying to do a query where I have two point tables one is
offenders and the other is schools I want to out put the list of
offenders by offender name and offender id within 500 meters of any
school but I don't think my query is correct. Can someone please help
me with this query

field's are offender.status(Witch would be true),offender.name, offender.id

 SELECT offenders, school_name
 FROM schools
 WHERE st_dwithin(the_geom, 'OFFENDER=TRUE',500)


Thanks,