SELECT microscopy_all.microscopy_id, microscopy_all.microscopy_name, microscopy_all.objective_name, microscopy_all.detector_name, microscopy_all.condenser_name, microscopy_all.illumination_name, microscopy_all.microscope_name, tblmicroscopy_filter.microscopy_filter_id, tblmicroscopy_filter.ex_filter_id, tblmicroscopy_filter.excitation_filter_angle, tblmicroscopy_filter.em_filter_id, tblmicroscopy_filter.emission_filter_angle FROM microscopy_all, tblmicroscopy_filter WHERE microscopy_all.microscopy_id = tblmicroscopy_filter.microscopy_id