VladikOtez

Untitled

Sep 30th, 2016
179
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT pc.f_name "Фамилия", i_name "Имя", o_name "Отчество", gr.name_long "Группа", kurs.name_long "Курс",
  2. bu.code "Код специальности", fo.name_long "Форма обучения", facult.name_long "Факультет"
  3. FROM o_personal_card pc
  4. JOIN o_work_place owp ON (pc.pcard_id=owp.pcard_pcard_id)
  5. JOIN o_use_base_units gr ON (gr.ubu_id=owp.ubu_ubu_id)
  6. JOIN o_use_base_units kurs ON (kurs.ubu_id=gr.ubu_ubu_id)
  7. JOIN o_base_unit kurs_bu ON (kurs_bu.bun_id=kurs.bun_bun_id)
  8. JOIN o_use_base_units spec ON (spec.ubu_id=kurs.ubu_ubu_id)
  9. JOIN o_base_unit bu ON (bu.bun_id=spec.bun_bun_id)
  10. JOIN o_use_base_units fo ON (fo.ubu_id=spec.ubu_ubu_id)
  11. JOIN o_use_base_units facult ON (facult.ubu_id=fo.ubu_ubu_id);
RAW Paste Data