Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created June 14, 2019 18:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/94583bd693dbb3d897eb6a35c3dc25d3 to your computer and use it in GitHub Desktop.
Save parzibyte/94583bd693dbb3d897eb6a35c3dc25d3 to your computer and use it in GitHub Desktop.
/*Los empleados que son del estado de Florida*/
select pp.*,ps.Name from HumanResources.Employee he
inner join Person.Person pp
on pp.BusinessEntityID = he.BusinessEntityID
inner join Person.BusinessEntityAddress pb
on pb.BusinessEntityID = pp.BusinessEntityID
inner join Person.Address pa
on pa.AddressID = pb.AddressID
inner join Person.StateProvince ps
on ps.StateProvinceID = pa.StateProvinceID
and ps.Name = 'Florida';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment