SELECT tblmicroscopy.microscopy_id, tblmicroscopy.microscopy_name, tblobjective.objective_name, tbldetector.detector_name, tblcondenser.condenser_name, tblillumination.illumination_name, tblmicroscope.microscope_name FROM tblmicroscopy, tblobjective, tbldetector, tblcondenser, tblillumination, tblmicroscope WHERE tblmicroscopy.objective_id = tblobjective.objective_id AND tblmicroscopy.detector_id = tbldetector.detector_id AND tblmicroscopy.condenser_id = tblcondenser.condenser_id AND tblmicroscopy.illumination_id = tblillumination.illumination_id AND tblmicroscopy.microscope_id = tblmicroscope.microscope_id