Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT faculty.name AS "Факультет", speciality.name AS "Специальность",
- entrant.surname || ' ' || entrant.name AS "ФИО",
- documents.series AS "ДипломНомер",
- split_part(documents.data, '#', 4) AS "Кем выдан",
- split_part(documents.data, '#', 5) AS "Место выдачи"
- from entrant, allset, speciality, faculty, documents
- WHERE entrant.delete = '0'
- AND entrant.allset_id = allset.id AND allset.speciality_id = speciality.id AND speciality.faculty_id = faculty.id
- AND speciality.name LIKE 'Маг %'
- AND entrant.id = documents.entrant_id AND documents.list_documents_id = 2
- ORDER BY 1,2,3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement