I have a user table and user table is linked with office and office linked with company?

See more:

SQL

MVC3

Company have many office and each office have many user and user link with roles and role link with permissions.
Can any one tell me if i get all the data in one query or get user data first then get the roles permission after login.Which method is fast get whole data in one query or get only first user data the rest data

What I have tried:

select * from company join office on Company.ID=Office.CompanyID
Join User on Office.ID=User.OfficeID
Join UserRole on User.ID=UserRole.UserID
Join Role on Role.ID=UserRole.RoleID
Join RolePermission on Role.ID=RolePermission.RoleID
Join Permission on RolePermission.PermissionID=Permission.ID
where userID="" AND password=""