VladikOtez

Untitled

Sep 29th, 2016
180
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=gr.ubu_ubu_id)
  6. JOIN o_use_base_units kurs ON (kurs.ubu_id=kurs.ubu_ubu_id)
  7. JOIN o_use_base_units spec ON (spec.ubu_id=kurs.ubu_ubu_id)
  8. JOIN o_use_base_units bu ON (bu.bun_id=bun.bun_bun_id)
  9. JOIN o_use_base_units fo ON (fo.ubu_id=spec.ubu_ubu_id)
  10. JOIN o_use_base_units facult ON (facult.ubu_id=fo.ubu_ubu_id);
RAW Paste Data