Skip to content
Programming101
Programming101

Learn everything about programming

  • Home
  • CS Subjects
    • IoT – Internet of Things
    • Digital Communication
    • Human Values
  • Programming Tutorials
    • C Programming
    • Data structures and Algorithms
    • 100+ Java Programs
    • 100+ C Programs
  • HackerRank Solutions
    • HackerRank Algorithms Solutions
    • HackerRank C problems solutions
    • HackerRank C++ problems solutions
    • HackerRank Java problems solutions
    • HackerRank Python problems solutions
Programming101
Programming101

Learn everything about programming

Leetcode Combine Two Tables problem solution

YASH PAL, 31 July 2024

In this Leetcode Combine Two Tables problem solution Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:

FirstName, LastName, City, State

Leetcode Combine Two Tables problem solution

Without using left join.

select P.FirstName,P.LastName,A.City,A.State
from Person P,Address A
where P.PersonId=A.PersonId
UNION
select P.FirstName,P.LastName,null,null
from Person P
where P.PersonId NOT IN (Select PersonId from Address
)

With left join.

select p.FirstName, p.LastName, a.City, a.State
from Person p left join Address a on (p.PersonID = a.PersonID)

TSQL solution using Left Join.

SELECT FirstName, LastName, City, State 
FROM Person
LEFT OUTER JOIN Address 
ON Person.PersonID = Address.PersonID

PLSQL solution.

select
p.firstname,
p.lastname,
a.city,
a.state
from person p , address a
where p.personid = a.personid(+)

coding problems

Post navigation

Previous post
Next post
  • HackerRank Separate the Numbers solution
  • How AI Is Revolutionizing Personalized Learning in Schools
  • GTA 5 is the Game of the Year for 2024 and 2025
  • Hackerrank Day 5 loops 30 days of code solution
  • Hackerrank Day 6 Lets Review 30 days of code solution
How to download udemy paid courses for free

Pages

  • About US
  • Contact US
  • Privacy Policy

Programing Practice

  • C Programs
  • java Programs

HackerRank Solutions

  • C
  • C++
  • Java
  • Python
  • Algorithm

Other

  • Leetcode Solutions
  • Interview Preparation

Programming Tutorials

  • DSA
  • C

CS Subjects

  • Digital Communication
  • Human Values
  • Internet Of Things
©2025 Programming101 | WordPress Theme by SuperbThemes