SQL |
SELECT stack_to_researcher.image_id, stack_to_researcher.image_url, stack_to_researcher.stack_pos, stack_to_researcher.x_dim, stack_to_researcher.y_dim, stack_to_researcher.z_coor, stack_to_researcher.stack_id, stack_to_researcher.time_id, stack_to_researcher.microscopy_filter_id, stack_to_researcher.substance_id, stack_to_researcher.name, stack_to_researcher.field_of_view_id, stack_to_researcher.slide_id, stack_to_researcher.experiment_id, stack_to_researcher.protocol_id, stack_to_researcher.cell_name, stack_to_researcher.cell_organism, stack_to_researcher.exp_title, stack_to_researcher.exp_date, stack_to_researcher.researcher_name, stack_to_researcher.researcher_email_add, stack_to_researcher.researcher_phone_num, stack_to_researcher.laboratory_id, tblprotocol.protocol_title, stack_to_researcher.stack_description, stack_to_researcher.x_coor, stack_to_researcher.y_coor FROM stack_to_researcher, tblprotocol WHERE stack_to_researcher.protocol_id = tblprotocol.protocol_id
|