Another workaround for combining two tables

  • 0

    I don`t like using the JOIN function, so I figured out how to solve this problem that is easier, plus it provides the additional values of City & State.
    This is an improved answer.

    SELECT P.FirstName, P.LastName, A.City, A.State FROM Person P, Address A WHERE p.PersonId = A.AddressId; 

Log in to reply

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.