引用其它表的计算列的表达式？解决办法

引用其它表的计算列的表达式？

SQL code

SELECT     dbo.xs.xuehao As 学号, dbo.xs.xingming As 姓名, dbo.xm.xm As 项目, dbo.xm.adfee　As 项目预交费, 5000 AS 实交费FROM         dbo.xs RIGHT OUTER JOIN                      dbo.xm ON dbo.xs.zhuanye = dbo.xm.zhuanye AND dbo.xs.nianji = dbo.xm.nianji

SQL code

SELECT     dbo.xs.xuehao As 学号, dbo.xs.xingming As 姓名, dbo.xm.xm As 项目, dbo.xm.adfee　As 项目预交费, dbo.fee.fee AS 实交费FROM         dbo.xs RIGHT OUTER JOIN                      dbo.xm ON dbo.xs.zhuanye = dbo.xm.zhuanye AND dbo.xs.nianji = dbo.xm.nianji                LEFT OUTER JOIN                      dbo.fee ON  dbo.xm.xm =dbo.fee.xm AND dbo.xs.xuehao = dbo.fee.xuehao