Difference between revisions of "schedule-conference"
From MGH Learn Pathology
| Line 14: | Line 14: | ||
|tables= conference,facultyMGH | |tables= conference,facultyMGH | ||
;join on= conference.presenter=facultyMGH.copath_id | ;join on= conference.presenter=facultyMGH.copath_id | ||
| − | ;fields=CONCAT(conference. | + | ;fields=CONCAT(conference.presenter, ' - ', conference.type)=name,facultyMGH.fullname=description,conference.date=Date |
;where=conference.conference='Thursday' | ;where=conference.conference='Thursday' | ||
;text color=#000000 | ;text color=#000000 | ||
