Cześć,
Będą mega wdzięczny za pomoc, otóż występuję mi błąd w kwerendzie:
Błąd składniowy (brak operatora) w wyrażeniu kwerendy 'imp.[contract]'
Na dole skrypt:
select
imp.[contract],
imp.[saldo_imp]
from
(select
customers.[contract_id] as contract,
imper.[imperment] as saldo_imp
from customers
inner join
(SELECT
IMPERMENT.[contract_id] as ici,
IMPERMENT.[ccy] as ic,
sum(IMPERMENT.[amount_integr]) as dodawanie,
dodawanie * kursy.ks as imperment
FROM IMPERMENT
inner join
(SELECT
waluty.[Kod_waluty] as kl,
Waluty.[Kurs_sredni] as ks
FROM Waluty) as kursy
on kursy.kl = IMPERMENT.[ccy]
where
IMPERMENT.[export_status] = 0
and IMPERMENT.[return_status] = 1
group by
IMPERMENT.[contract_id],
IMPERMENT.[ccy],
kursy.ks) as imper
on imper.[ici] = customers.[contract_id]) as imp
inner join
(SELECT
Accrual_Table.[contract_id] as ci,
Accrual_Table.[ccy] as c,
sum(Accrual_Table.[amount_accrual]) as suma,
suma * w.kr as Accrual
FROM Accrual_Table
inner join
(SELECT
waluty.[Kod_waluty] as kw,
Waluty.[Kurs_sredni] as kr
FROM Waluty) as w
on w.kw = Accrual_Table.[ccy]
group by
Accrual_Table.[contract_id],
Accrual_Table.[ccy],
w.kr) as nowy
on nowy.[ci] = imp.[contract]
Bardzo proszę o pomoc
pozdrawiam,