SELECT DISTINCT first_table.number, record_ids FROM first_table, second_table WHERE second_table.number = first_table_number;