breeding_programsxgenotyping_protocols

SELECT materialized_phenoview.breeding_program_id,

    materialized_genoview.genotyping_protocol_id

   FROM (materialized_phenoview

     JOIN materialized_genoview USING (accession_id))

  GROUP BY materialized_phenoview.breeding_program_id, materialized_genoview.genotyping_protocol_id;