selectul e urmatorul: 

SELECT func_qjn22_Grp_PfVkn_SOLL.VknID, func_qjn22_Grp_PfVkn_SOLL.TypNr,
func_qjn22_Grp_PfVkn_SOLL.GenNr, func_qjn22_Grp_PfVkn_SOLL.Folge,
func_qjn22_Grp_PfVkn_SOLL.ArtNr, func_qjn22_Grp_PfVkn_SOLL.AnzKrit AS PfSoll,
(CASE WHEN PfSoll > func_qjn22_Grp_PfVkn_SOLL.AnzKrit THEN func_qjn22_Grp_PfVkn_SOLL.AnzKrit ELSE func_qjn21_grp_PfVkn_ist.AnzKrit END) AS PfIst,
PfSoll*10 + (CASE PfIst WHEN null THEN 0 ELSE PfIst END) AS Result
FROM qjn21_Grp_PfVkn_IST() AS func_qjn21_Grp_PfVkn_IST RIGHT JOIN qjn22_Grp_PfVkn_SOLL() AS func_qjn22_Grp_PfVkn_SOLL
ON func_qjn21_Grp_PfVkn_IST.VknID = func_qjn22_Grp_PfVkn_SOLL.VknID

iar eroarea: Msg 207, Level 16, State 1, Line 4
Invalid column name 'PfSoll'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'PfSoll'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'PfIst'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'PfIst' 

ok....nu poate folosi in linia de select numele data dupa AS...

de ce?....din moment ce sunt definitte mai inainte si ar trebui sa fie cunoscute nu invalide...

 multumesc anticipat...