1 select * from 
 2 
 3 (
 4 
 5     select s1.stuID,
 6 
 7     s1.stuName,
 8 
 9     case s1.stuSex
10 
11         when 'f' then '女'
12 
13         else '男'
14     
15     end as stuSex,
16 
17     datediff(yy,s1.stuBirthdate,getdate()) as stuAge,
18 
19     convert(varchar(10),s1.stuStudyDate,101) as stuStudyDate,
20 
21     s1.stuEmail,
22 
23     s1.stuPhone,
24 
25     s2.testBase,
26 
27     s2.testBeyond,
28 
29     s2.testName,
30 
31     convert(varchar(10),s2.testDate,101) as testDate,
32 
33     s3.className,
34 
35     s3.classDescription
36 
37         from
38 
39         Student as s1
40 
41             inner join
42 
43         Score as s2
44 
45             on s1.stuID=s2.stuID
46 
47         inner join
48 
49             Course as s3
50 
51         on s1.classID=s3.classID
52 
53             where
54 
55         s1.stuIsDel=0
56 
57         ) as tb1
58 
59         where
60 
61             tb1.stuAge=20
62 
63         and
64 
65             tb1.stuSex='女'