CREATE VIEW webcenter.Users_Companies
(user_ID, user_name, user_firstname, user_lastname, user_email ,
company_name, location_name, location_shortname )
as select
webcenter.users.Id, webcenter.users.UserName, webcenter.users.FirstName,webcenter.users.LastName,
webcenter.users.Email,webcenter.companies.LegalName,webcenter.Locations.LocationName,
webcenter.Locations.LocationShortName
from webcenter.users , webcenter.companies , webcenter.Locations
where webcenter.users.Location_Id = webcenter.Locations.Id
and webcenter.Locations.Company_ID = webcenter.companies.id