SQL |
SELECT image_to_lab.image_id, image_to_lab.image_url, image_to_lab.stack_pos, image_to_lab.x_dim, image_to_lab.y_dim, image_to_lab.z_coor, image_to_lab.stack_id, image_to_lab.substance_id, image_to_lab.time_id, image_to_lab.name, image_to_lab.field_of_view_id, image_to_lab.slide_id, image_to_lab.experiment_id, image_to_lab.protocol_id, image_to_lab.label_id, image_to_lab.cell_name, image_to_lab.cell_organism, image_to_lab.exp_title, image_to_lab.exp_date, image_to_lab.researcher_name, image_to_lab.researcher_email_add, image_to_lab.researcher_phone_num, image_to_lab.laboratory_id, image_to_lab.lab_name, image_to_lab.lab_address, image_to_lab.lab_email_add, image_to_lab.lab_phone_num, image_to_lab.protocol_title, image_to_lab.microscopy_filter_id, mf_microscopy.microscopy_id, mf_microscopy.microscopy_name, mf_microscopy.objective_name, mf_microscopy.detector_name, mf_microscopy.condenser_name, mf_microscopy.illumination_name, mf_microscopy.microscope_name, mf_microscopy.ex_filter_id, mf_microscopy.excitation_filter_angle, mf_microscopy.em_filter_id, mf_microscopy.emission_filter_angle, image_to_lab.stack_description, image_to_lab.x_coor, image_to_lab.y_coor FROM image_to_lab, mf_microscopy WHERE image_to_lab.microscopy_filter_id = mf_microscopy.microscopy_filter_id
|