Newbie question to SQL


  • 0
    W

    Hi! I'm a complete beginner to mySQL. I have came up with such solution:

    # Write your MySQL query statement below
    SELECT Person.FirstName, Person.LastName, Address.City, Address.State
    FROM Person
    LEFT JOIN Address ON 1
    

    What I wanted to do? First I select the proper entries from Person and join with address. However, this solution is not optimal, it takes a lot time. Why? I have no idea. Could you guide what I am doing wrong, hits perhaps? I am now studying the site http://www.mysqltutorial.org , will I find answers there?


  • 0
    W
    This post is deleted!

Log in to reply
 

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