webleave view groupbase level all emp

select Employee.EmpNumber, Employee.EmpName, GroupBase.BaseName, GroupBase.BaseSym
from dbo.Employee
join dbo.GroupBase on Employee.GBID = GroupBase.GBID

==============OR==================

select Employee.EmpName, GroupBase.BaseSym from dbo.Employee join dbo.GroupBase on Employee.GBID = GroupBase.GBID