a guest Feb 19th, 2020 77 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select j.EmployeeID, ct.id as ThemeID
- from json_populate_recordset(null::eisConsultationStudents, p_StudentIDs) j
- inner join eisEmployee e on j.EmployeeID = e.ID and e.IsActual
- left outer join eisCourseTheme ct on j.ThemeID = ct.ID
RAW Paste Data