Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Student.SFname, Student.SSname, Student.Area, (Year(Now())-Year([DOB])) AS Age, Student.DOB
- FROM Student INNER JOIN (Course INNER JOIN Enrolment ON Course.CourseNo = Enrolment.CourseNo) ON Student.StudentNo = Enrolment.StudentNo
- WHERE (((Year([DOB])) Between 1960 And 1988) AND ((Student.Male)=Yes));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement