Hi everybory,
Im trying to do a query in ttadv3180m000 to find a problema in my "stoc movimentation". Its the sintax below:
select tdinv150.orno
from tdinv150
where tdinv150.koor = tckoor.act.sfc
and not exists( select tisfc001.pdno
from tisfc001
where tisfc001.pdno = tdinv150.orno )

Therefor, the bwmessage appears when I try run the query.
Some one could help me?

Best regards.

Hi,

What error message are you getting? Your query looks fine to me. Post your error message screenshot.

Bye

Good morning bigjack,
The error is in attachaments. This select works well in program script, but in the query only not.
Best regards.
Flavio.

I think it just your spacing - try this:

select tdinv150.orno
from tdinv150
where tdinv150.koor = tckoor.act.sfc
and not exists (select tisfc001.pdno from tisfc001 where tisfc001.pdno = tdinv150.orno)

Hi Mark, it works very well, you are totaly rigth.

Tks a lot.
Flavio.