stack_to_lab - View
HomeTablesSchemasDiagramsForeign KeysIndexes

Namestack_to_lab
SQL
SELECT stack_to_label.image_id, stack_to_label.image_url, stack_to_label.stack_pos, stack_to_label.x_dim, stack_to_label.y_dim, stack_to_label.z_coor, stack_to_label.stack_id, stack_to_label.time_id, stack_to_label.microscopy_filter_id, stack_to_label.substance_id, stack_to_label.name, stack_to_label.field_of_view_id, stack_to_label.slide_id, stack_to_label.experiment_id, stack_to_label.protocol_id, stack_to_label.label_id, stack_to_label.cell_name, stack_to_label.cell_organism, stack_to_label.exp_title, stack_to_label.exp_date, stack_to_label.researcher_name, stack_to_label.researcher_email_add, stack_to_label.researcher_phone_num, stack_to_label.laboratory_id, tbllaboratory.lab_name, tbllaboratory.lab_address, tbllaboratory.lab_email_add, tbllaboratory.lab_phone_num, stack_to_label.protocol_title, stack_to_label.stack_description, stack_to_label.x_coor, stack_to_label.y_coor FROM stack_to_label, tbllaboratory WHERE stack_to_label.laboratory_id = tbllaboratory.laboratory_id