开发者社区 问答 正文

join and name different types of joins by SQL?

已解决

Define join and name different types of joins?

展开
收起
1780169608831412 2021-10-16 14:39:53 561 分享 版权
1 条回答
写回答
取消 提交回答
  • 网络规划设计师、敏捷专家、CISP、ITSS服务经理、ACA全科目、ACP4项、ACE、CBP、CDSP、CZTP等。拥有 PRINCE2 Foundation/Practitioner、CCSK、ITIL、ISO27001、PMP等多项国际认证。 专利5+、期刊10+、知识产权师。核心期刊审稿人。
    采纳回答

    Join keyword is used to fetch data from two or more related tables. It returns rows where there is at least one match in both the tables included in the join. Read more here. Type of joins are:

    Right join
    Outer join
    Full join
    Cross join
    Self join.
    
    2021-10-16 15:34:13
    赞同 1 展开评论