Simple 2 lines with explanation. ( You'll love it guaranteed.)
Here we have to use Outer Joins in order to get expected results. because we want every row from Person( which is we are specifying first using SELECT statement
Here we have to use Outer Joins in order to get expected results. because we want every row from Person( which is we are specifying first using SELECT statement.) table so we are using LEFT JOIN on contrary if we wanted every row from address table we would have used RIGHT JOIN. I hope you have understood.\n\nHow to remember what is left, what is right?\n-Simple\nWhatever you are accessing first = LEFT -----  1 = LEFT\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t2 = RIGHT\n\n```\nSELECT p.firstName, p.lastName, a.city, a.state FROM Person p  --accessing first hench LEFT\nLEFT JOIN Address a USING (personId) -- accessing second hence RIGHT. but we want every row in person so LEFT JOIN.\n```\n\nIf you Learned something new please give it upvote;\notherwise thank you for having a look \uD83D\uDE4F\uD83C\uDFFB
['MySQL']