error in select statement

[Former Member]

select kostl from csks into table incsks

where csks-datbi =< sstdate

and csks-datab => snddate

and csks-kosar in ('i','p') .

it is giving the following error.what can be the reason.

Error: Field "CSKS-DATBI" unknown.

[RichHeilman]

Try this. You don't need table name in WHERE clause.

select kostl from csks into table incsks
         where datbi =< sstdate
           and datab => snddate
           and kosar in ('i','p') .

Regards,

RIch Heilman

[Former Member]

select kostl 
into table incsks
from csks 
where datbi LE sstdate
and datab GE snddate
and kosar in ('i','p') .

Greetings,

Blag.

[Former Member]

yeah,

i realised, how could i be so dumm to do this error.

thanks a lot.