• sql join


    SQL JOIN

    A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

    Let's look at a selection from the "Orders" table:

    OrderIDCustomerIDOrderDate
    10308 2 1996-09-18
    10309 37 1996-09-19
    10310 77 1996-09-20

    Then, look at a selection from the "Customers" table:

    CustomerIDCustomerNameContactNameCountry
    1 Alfreds Futterkiste Maria Anders Germany
    2 Ana Trujillo Emparedados y helados Ana Trujillo Mexico
    3 Antonio Moreno Taquería Antonio Moreno Mexico

    Notice that the "CustomerID" column in the "Orders" table refers to the "CustomerID" in the "Customers" table. The relationship between the two tables above is the "CustomerID" column.

    Then, we can create the following SQL statement (that contains an INNER JOIN), that selects records that have matching values in both tables:

    Example

    SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
    FROM Orders
    INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;
    Try it Yourself »

    and it will produce something like this:

    OrderIDCustomerNameOrderDate
    10308 Ana Trujillo Emparedados y helados 9/18/1996
    10365 Antonio Moreno Taquería 11/27/1996
    10383 Around the Horn 12/16/1996
    10355 Around the Horn 11/15/1996
    10278 Berglunds snabbköp 8/12/1996

    Different Types of SQL JOINs

    Here are the different types of the JOINs in SQL:

    • (INNER) JOIN: Returns records that have matching values in both tables
    • LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
    • RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
    • FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table

       

  • 相关阅读:
    手机浏览器的viewport(视觉窗口)
    google开源了google chrome android
    Yii 直接执行SQL语句(转)
    WebKit学习网址收集
    Yii CDbCriteria的常用方法
    现货黄金入门知识普及一:图形分析之K线理论
    java 获取当前函数名
    yii url生成
    android 判断屏幕是否关闭
    yii yiiplayground
  • 原文地址:https://www.cnblogs.com/oxspirt/p/11545955.html
Copyright © 2020-2023  润新知