my $SQLquery = " SELECT checklist.id FROM group_management, User_group_management_mapping, profiles, checklist,checklist_group_mapping WHERE User_group_management_mapping.userid = ? and profiles.userid = User_group_management_mapping.userid and group_management.id = User_group_management_mapping.groupid and checklist_group_mapping.checklist_id = checklist.id and checklist_group_mapping.group_id = group_management.id"; my $sth = $dbh->prepare( $SQLquery ); $sth->execute( $usr );