in reply to Perl database access

Try somthing along the lines of:

  SELECT table1.id,state,city,discription,comment
    FROM table1 NATURAL LEFT JOIN table2
   WHERE state=$state

Or else specify the id with a USING, ON, or WHERE clause.