Hello!

I have strange problem. In SQL statement:
SELECT p.datumdokumenta,p.sifrastranke,naziv1,(if p.veznazapstevprometa='0'
then p.veznidokument else (select z.ppsklic from SAOP_DKPROMET z where
z.zaporednastevilkaprometa=p.veznazapstevprometa) endif) as dokument,
(if p.veznazapstevprometa='0' then null else (select z.datumvalute from
SAOP_DKPROMET z where z.zaporednastevilkaprometa=p.veznazapstevprometa)
endif) as datum_zapadlosti,
isnull(datediff( day, DATUM_ZAPADLOSTI, DATUM_PLACILA ),0) as
razlika,S.FIZ_PRAV_OSEBA,


cast(p.datumdokumenta as date) as
datum_PLACILA,p.znesekdobro,p.znesekzaprtodobro FROM "DBA"."SAOP_DKPROMET" p
LEFT outer join sif_stranke s on p.sifrastranke=s.SIFRA_SAOP
where p.letnicaposlovnegaleta=f_get_poslovno_leto_saop(1 ) and p.sifrakonta
in (120000,120400,1211000,1212000,1213900) and p.sifratemeljnice=410

you see on the end in (120000,120400,1211000,1212000,1213900). With this I
get result, but where I change here to

in (select list(konto) from sif_saop_konti_parametri where podjetje_id = 1
and vrsta_uporabe = 1 and status = 1)

I don't get any result. But when I run this subselect: select list(konto)
from sif_saop_konti_parametri where podjetje_id = 1 and vrsta_uporabe = 1
and status = 1 I get the same result like in first statement.

What coul be problem?

Regards

Tomaz

Hi Tomaz,

drop the LIST keyword from your embedded query:

select konto from sif_saop_konti_parametri ...

HTH

Chris Werner
f+s software gmbh

"Tomaz" <kralj.soft4you (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:4a926415$1 (AT) forums-1-dub (DOT) ..