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

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

create view
var
date1, dat1, date2, dat2, date3, dat3:date;
XlRes: Boolean;
aFileName: String;
as
Select *
From 
basefin, 
basedoc, 
stepdoc, 
katsopr,
katmc katmc1,
tkvart,
t_katmc _katmc
, KatMC
, t_katmc
, t_bf
, t_do
, toplat
Where
((
    katmc.nrec==_katmc.nrec
//and 10051==basefin.tipdoc
//только по платежным поручениям
  and 1==basefin.direct
  and 2==basefin.tidkgal(noindex)

//and '2909'==basefin.nodoc(noindex)

and dat1<<=basefin.ddoc
and dat2>>=basefin.ddoc(noindex)
and basefin.cbasedoc==basedoc.nrec

and word(201)==basedoc.viddoc(noindex)

and dat3<<=basedoc.ddoc(noindex)

and basedoc.nrec==stepdoc.cbasedoc
and stepdoc.nrec==katsopr.cstepdoc
and katsopr.cstepdoc == basefin.cstepdoc 
and katsopr.nrec == spsopr.csopr
and 1 == spsopr.prmc
and spsopr.cmcusl == katmc1.nrec
));