Friday, May 7, 2021
More

    Combine Two Tables

    Must Read

    Programmerhttp://www.improgrammer.net
    We started this site to inspire young minds to motivate and encourage them towards Programming Language. In this site you will get programming tutorials, tech, programming facts, programming fun and programming blogs.

    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 is the primary key column for this table.
    

    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

    Solution :
    Approach 1:
    SELECT p.FirstName, p.LastName, a.City, a.State
    FROM Person p LEFT OUTER JOIN Address a
    ON p.PersonId=a.PersonId

    Approach 2:

    SELECT p.FirstName, p.LastName, a.City, a.State
    FROM Person p LEFT JOIN Address a
    ON p.PersonId=a.PersonId

     

    Previous articleNth Highest Salary
    Next articleSwap Sex Field

    Latest Articles

    More Recipes Like This