Please enable JavaScript.

Coggle requires JavaScript to display documents.

ERD, CONSTRAINTS, TRUNCATE TABLE, CREATE TABLE, Character Functions,…

- - - - Non-equijoins relate one row to another by way of non-equal comparisons, such as comparisons of greater or lesser value or perhaps comparisons that look for a range of values. Such joins are unusual but important.
      - Self-join
        
        A self-join is a table that is joined to itself. A self-join is based on the value in a column of a table as it compares to the values within another column—often a different column—in the same table. The self-join returns one or more rows from a table that are merged with other rows in the same table based on the join criteria.