Filtering Gridview results

I have the following query which returns all records from our membership DB -
SELECT dbo.UserProfiles.UserId, dbo.UserProfiles.Surname, dbo.UserProfiles.FirstName, dbo.UserProfiles.Organisation, dbo.UserProfiles.Address1, dbo.UserProfiles.Address2, dbo.UserProfiles.Postcode, dbo.UserProfiles.MemberType, dbo.UserProfiles.DateLastPaid, dbo.UserProfiles.Comments, dbo.UserProfiles.DateLastReminder, dbo.aspnet_Users.UserName, dbo.aspnet_Membership.IsApproved FROM dbo.UserProfiles INNER JOIN dbo.aspnet_Users ON dbo.UserProfiles.UserId = dbo.aspnet_Users.UserId INNER JOIN dbo.aspnet_Membership ON dbo.aspnet_Users.UserId = dbo.aspnet_Membership.UserId ORDER BY dbo.UserProfiles.Surname What would I need to do if I wanted only the records returned for those members whose MemberType is "Student".
Thanks,
Mart