SELECT Member.*, User.RegistrationNumber, EmailId, Mobile FROM `Member` Join User where Member.UserId = User.UserID