Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > SQL 必知必会笔记11创建高级联结

SQL 必知必会笔记11创建高级联结

WBOY
Release： 2016-06-07 17:39:16
Original
975 people have browsed it

1. 使用表别名 SQL 除了可以对列名和计算字段使用别名，还允许给表名起别名。这样 做有两个主要理由： 缩短SQL 语句； 允许在一条SELECT 语句中多次使用相同的表。 使用表别名示例: 1 SELECT cust_name, cust_contact 2 FROM Customers AS C, Orders AS O, O

1. 使用表别名

SQL 除了可以对列名和计算字段使用别名，还允许给表名起别名。这样 做有两个主要理由：

  • 缩短SQL 语句；
  • 允许在一条SELECT 语句中多次使用相同的表。

    • 使用表别名示例:

    1 SELECT cust_name, cust_contact 2 FROM Customers AS C, Orders AS O, OrderItems AS OI 3 WHERE C.cust_id = O.cust_id 4 AND OI.order_num = O.order_num ; ，

    Related labels：
    create Must know notes advanced
    source：php.cn
    Previous article： 不正常关机引起的数据库置疑 Next article： 检索表上某一字段的不重复记录
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
    From 2024-04-06 21:23:40
    0
    2
    530
    Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
    From 2024-04-06 21:21:07
    0
    1
    474
    How to solve the mysterious white space at the bottom of the page in CSS I'm trying to build a simple webpage using Bootstrap and D3, but I don't know how to get r...
    From 2024-04-06 20:22:15
    0
    1
    454
    Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
    From 2024-04-06 20:18:18
    0
    1
    483
    for loop randomly goes from 1 to 0 Basically, every time the page is refreshed, the for loop has the potential to change from...
    From 2024-04-06 16:48:14
    0
    1
    393
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template