INNER JOIN Sample (default join in SQL)

SELECT     *
FROM         ETigers.UserRole INNER JOIN
                      ETigers.UserInfo ON ETigers.UserRole.UserInfoID = ETigers.UserInfo.UserInfoID