Newbie question to SQL

  • 0

    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 , will I find answers there?

  • 0
    This post is deleted!

Log in to reply

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