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