Another workaround for combining two tables


  • 0
    P

    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.