• Skip to primary navigation
  • Skip to content
  • Skip to footer
Thomas Ngo Thomas Ngo
  • Home
  • Journal
  • Tags
  • About

    Thomas Ngo

    Software Engineer

    • Stanton, California
    • Email
    • GitHub
    • Resume

    SQL problem - Combine Two Tables

    February 2, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • Query

    Problem

    problem

    Query

    SELECT firstName, lastName, city, state
    FROM Person AS p
    LEFT JOIN Address as a
    ON p.personId = a.personId
    

    Tags: SQL

    Updated: February 2, 2024

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    Problem of The Day: Letter Combinations of a Phone Number

    January 23, 2026 2 minute read

    Problem Statement

    Problem of The Day: Find Peak Element

    January 20, 2026 less than 1 minute read

    Problem Statement

    Problem of The Day: Successful Pairs of Spells and Potions

    January 15, 2026 1 minute read

    Problem Statement

    Problem of The Day: Total Cost to Hire K Workers

    January 15, 2026 less than 1 minute read

    Problem Statement

    • Follow:
    • GitHub
    • LinkedIn
    © 2026 Thomas Ngo.