0

I am trying to figure out how to convert a JOIN to a subquery. I am using AdventureWorks2019 database and I am pulling data from two tables. My JOIN statement I created is:

SELECT FirstName, MiddleName, LastName, StateProvinceID
FROM Person.Person AS P
  JOIN Person.BusinessEntityAddress AS BEA
    ON P.BusinessEntityID = BEA.AddressID
  JOIN Person.Address AS A
    ON BEA.BusinessEntityID = A.AddressID
WHERE StateProvinceID = 79;

How do I turn this into a subquery? Do I create them in FROM or WHERE?

JNevill
  • 46,980
  • 4
  • 38
  • 63
BCT
  • 11
  • 1

0 Answers0