--- filter_api.php.1.59 2004-10-05 13:29:11.000000000 +0200 +++ filter_api.php 2004-10-13 17:31:31.000000000 +0200 @@ -469,8 +469,8 @@ $t_from_clauses = array( $t_bug_text_table, $t_project_table, $t_bug_table ); - array_push( $t_join_clauses, "INNER JOIN $t_bugnote_table ON $t_bugnote_table.bug_id = $t_bug_table.id" ); - array_push( $t_join_clauses, "INNER JOIN $t_bugnote_text_table ON $t_bugnote_text_table.id = $t_bugnote_table.bugnote_text_id" ); + array_push( $t_join_clauses, "LEFT JOIN $t_bugnote_table ON $t_bugnote_table.bug_id = $t_bug_table.id" ); + array_push( $t_join_clauses, "LEFT JOIN $t_bugnote_text_table ON $t_bugnote_text_table.id = $t_bugnote_table.bugnote_text_id" ); } else { $t_from_clauses = array( $t_project_table, $t_bug_table ); }