my $stmt = qq~SELECT * FROM registrants, hotels, cadavers WHERE registrants.registrant_id = ? AND registrants.registrant_id = hotels.registrant_id~; %results = % { $dbh->selectrow_hashref($stmt, undef, $registrant_id) };