It should be a simple select statement since its all on one table. Try something like the following:
Code:
SELECT [information],state,county FROM EMIO_Agency_Column WHERE state='state' AND county='county'
where [information] are the other columns you want to pull.
This is a very simple query you're needing help with, should you really be pulling medical records? Are you familiar with SQL injection?