Combine Two Tables Visualizer & Solution | Rulcode

301. Combine Two Tables

Easy

Topics

Hint

Example 1:

Input:

Person table:

personId	lastName	firstName
1	Wang	Allen
2	Alice	Bob

Address table:

addressId	personId	city	state
1	2	New York City	New York
2	3	Leetcode	California

Output:

firstName	lastName	city	state
Allen	Wang	Null	Null
Bob	Alice	New York City	New York

Explanation:

For personId = 1 (Allen Wang), there is no matching entry in the Address table. Therefore, the LEFT JOIN correctly reports Null for both city and state for this person.

For personId = 2 (Bob Alice), there is a matching entry in the Address table (addressId = 1). The LEFT JOIN successfully retrieves and displays 'New York City' and 'New York' for this person's city and state.

Note that addressId = 2 has personId = 3, which does not exist in the Person table. Because we are using a LEFT JOIN with Person as the left table, this address record is ignored, ensuring only persons from the Person table are included in the output.

Constraints:

Loading problem details...

301. Combine Two Tables

Example 1:

Person table:

Address table:

Constraints:

Learn

Topics

Hint

Use Cases

301. Combine Two Tables

Example 1:

Person table:

Address table:

Constraints:

Learn

Topics

Hint

Use Cases