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?