DbWrench Documentation: PSLID |
Home | Tables | Diagrams | Foreign Keys | Indexes |
View: experiment_to_researcher | |
Name | experiment_to_researcher |
SQL |
SELECT tblexperiment.researcher_id, tblexperiment.experiment_id, tblexperiment.exp_title, tblexperiment.exp_date, tblresearcher.researcher_name, tblresearcher.researcher_email_add, tblresearcher.researcher_phone_num, tblresearcher.laboratory_id FROM tblresearcher, tblexperiment WHERE tblexperiment.researcher_id = tblresearcher.researcher_id |