SQL |
SELECT experiment_to_researcher.researcher_id, experiment_to_researcher.experiment_id, experiment_to_researcher.exp_title, experiment_to_researcher.exp_date, experiment_to_researcher.researcher_name, experiment_to_researcher.researcher_email_add, experiment_to_researcher.researcher_phone_num, tbllaboratory.laboratory_id, tbllaboratory.lab_name, tbllaboratory.lab_address, tbllaboratory.lab_email_add, tbllaboratory.lab_phone_num FROM tbllaboratory, experiment_to_researcher WHERE tbllaboratory.laboratory_id = experiment_to_researcher.laboratory_id
|