Всем здрасти!
Делаю простейший запрос:
sel ect m.nndoc as FULLNAME,
m.dataoper as DATEOPER,
m.nndoc as NUMDOC,
m.nameoper as NAMEOPER,
m.dt_schet as KORRSCHET,
m.dt_code as KORRANAL,
m.summa as SUMM
fr om main m
where m.dataoper>=:dbp and m.dataoper<=:dep and m.kt_schet='7401'
uni on
sel ect m.nndoc as FULLNAME,
m.dataoper as DATEOPER,
m.nndoc as NUMDOC,
m.nameoper as NAMEOPER,
m.kt_schet as KORRSCHET,
m.kt_code as KORRANAL,
m.summa as SUMM
fr om main m
where m.dataoper>=:dbp and m.dataoper<=:dep and m.dt_schet='7401';
в результате ош ишибка, подскажите где я ошибаюсь
Делаю простейший запрос:
sel ect m.nndoc as FULLNAME,
m.dataoper as DATEOPER,
m.nndoc as NUMDOC,
m.nameoper as NAMEOPER,
m.dt_schet as KORRSCHET,
m.dt_code as KORRANAL,
m.summa as SUMM
fr om main m
where m.dataoper>=:dbp and m.dataoper<=:dep and m.kt_schet='7401'
uni on
sel ect m.nndoc as FULLNAME,
m.dataoper as DATEOPER,
m.nndoc as NUMDOC,
m.nameoper as NAMEOPER,
m.kt_schet as KORRSCHET,
m.kt_code as KORRANAL,
m.summa as SUMM
fr om main m
where m.dataoper>=:dbp and m.dataoper<=:dep and m.dt_schet='7401';
в результате ош ишибка, подскажите где я ошибаюсь