[Leetcode]-database-combine Tables

Table:Person

+-------------+---------+| Column Name | Type    |+-------------+---------+| PersonId    | int     | | FirstName   | varchar | | LastName    | varchar |+-------------+---------+personid is the primary key, column for this table.

Table:Address

+-------------+---------+| Column Name | Type    |+-------------+---------+| Addressid   | int     | | PersonId    | int     | | City        | varchar | | State       | varchar |+-------------+---------+addressid are the primary key column for this table.

Write a SQL query for a report this provides the following information for each person in the person table, regardless if There is a address for each of those people:

FirstName, LastName, city, state


Requirements: Simple table connection

Query: SQL

CREATE TABLE Person (
PersonId TINYINT UNSIGNED auto_increment PRIMARY KEY,
FirstName varchar (20),
LastName varchar (20)
) Engine=myisam Charset=utf8;
CREATE TABLE Address (
Addressid TINYINT UNSIGNED auto_increment PRIMARY KEY,
PersonId TINYINT UNSIGNED,
City VARCHAR (20),
State VARCHAR (20)
) Engine=myisam Charset=utf8;

SELECT t1. Firstname,t1. Lastname,t2. City,t2. State
From person T1
Left JOIN Address T2 on T1. Personid=t2. PersonId

[Leetcode]-database-combine Tables