in reply to Perl database access
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.