Advertisement
Guest User

Untitled

a guest
May 21st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.30 KB | None | 0 0
  1. SELECT Student.SFname, Student.SSname, Student.Area, (Year(Now())-Year([DOB])) AS Age, Student.DOB
  2. FROM Student INNER JOIN (Course INNER JOIN Enrolment ON Course.CourseNo = Enrolment.CourseNo) ON Student.StudentNo = Enrolment.StudentNo
  3. WHERE (((Year([DOB])) Between 1960 And 1988) AND ((Student.Male)=Yes));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement