Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT cRefNum, cName, cProgram || '-' || cCode || '-' || cSection as CourseDesc, cTimeStart, cTimeEnd, cDay, ct.cCampus, cBuildingSection || cRoom AS Room, cSchedType
- from coursedetails cd inner join coursetimes ct
- using (cRefNum)
- where cRefNum = 3816;
- select cRefNum, LISTAGG(fname|| ' ' || lname, ', ') within group (order by cRefNum) as Teachers
- from teachers
- where cRefNum = 3816
- group by cRefNum;
Add Comment
Please, Sign In to add comment