Advertisement
letu

Дипломы магистров

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