#this part might be different depending on how your db does SQL my $people_query = $dbh->prepare("SELECT ss_number, f_name, l_name, state FROM people, states WHERE people.stID = states.stID");