my $quer = "SELECT checklist.id FROM group_management,User_group_management_mapping,profiles,checklist,checklist_group_mapping WHERE User_group_management_mapping.userid = $usr 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 $query = $dbh -> prepare($quer); $query-> execute(); #### 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 );