Галактика в вопросах и ответах

Код: Выделить всё

.create view ViewKorg
as select * from KatOrg, Katsopr
where ((АКТ_нрек==KatSopr.Nrec and
        KatSopr.Corg==KatOrg.nrec));
.create view ViewDolgFace
as select * from Attrnam, attrval
where   ((ViewKorg.katorg.nrec=attrval.crec
        and attrnam.name=’В лице кого’))  and
((Attrval.cattrnam==attrnam.nrec and
        1418==attrval.wtable));
.create view ViewRukovod
as select * from Attrnam, attrval
where 
     ViewKorg.katorg.nrec=attrval.crec
      and attrnam.name=’ФИО руководителя’
and
((Attrval.cattrnam==attrnam.nrec and
      1418==attrval.wtable));
.fields
ViewDolgFace.attrval.vstring
ViewRukovod.attrval.vstring
.endfields