stack_mf - View
HomeTablesDiagramsForeign KeysIndexes

Namestack_mf
SQL
SELECT stack_to_lab.image_id, stack_to_lab.image_url, stack_to_lab.stack_pos, stack_to_lab.x_dim, stack_to_lab.y_dim, stack_to_lab.z_coor, stack_to_lab.stack_id, stack_to_lab.time_id, stack_to_lab.substance_id, stack_to_lab.name, stack_to_lab.field_of_view_id, stack_to_lab.slide_id, stack_to_lab.experiment_id, stack_to_lab.protocol_id, stack_to_lab.label_id, stack_to_lab.cell_name, stack_to_lab.cell_organism, stack_to_lab.exp_title, stack_to_lab.exp_date, stack_to_lab.researcher_name, stack_to_lab.researcher_email_add, stack_to_lab.researcher_phone_num, stack_to_lab.laboratory_id, stack_to_lab.lab_name, stack_to_lab.lab_address, stack_to_lab.lab_email_add, stack_to_lab.lab_phone_num, stack_to_lab.protocol_title, stack_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, stack_to_lab.stack_description, stack_to_lab.x_coor, stack_to_lab.y_coor FROM stack_to_lab, mf_microscopy WHERE stack_to_lab.microscopy_filter_id = mf_microscopy.microscopy_filter_id