-
-
Save parzibyte/94583bd693dbb3d897eb6a35c3dc25d3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/*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