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