Hallo,

die FROM-Anweisung steht an der falschen Stelle:

Select kustp.*, (Select text from ANSP where
key1=SUBSTR(DIGITS(KUANID), 1 , 1) and
key2=SUBSTR(DIGITS(KUANID), 2 , 1) and
key3=SUBSTR(DIGITS(KUANID), 3 , 1) ) AS anspid,
(Select text from ANSP where
key1=SUBSTR(DIGITS(KUANAD), 1 , 1) and
key2=SUBSTR(DIGITS(KUANAD), 2 , 1) and
key3=SUBSTR(DIGITS(KUANAD), 3 , 1) ) AS anspad
from kustp
where kuknr = 4711

Gruß
M.Withake