Skip to content

GlueSQL

Data Joining

GlueSQL

Introduction
Getting Started
Getting Started
SQL Syntax
SQL Syntax
- Introduction
- Statements
  Statements
  - Querying
    Querying
    
    WHERE
    
    JOIN
    
    LIMIT & OFFSET
    
    Aggregation
    
    Schemaless Data
  - Data definition
    Data definition
    
    CREATE TABLE
    
    DROP TABLE
    
    CREATE INDEX
    
    DROP INDEX
    
    ALTER TABLE
  - Data manipulation
    Data manipulation
    
    INSERT
    
    UPDATE
    
    DELETE
  - Transaction
  - Metadata
    Metadata
    
    SHOW TABLES
    
    Data Dictionary
- Data types
  Data types
  - BOOLEAN
  - Integer Types
  - FLOAT
  - TEXT
  - DECIMAL
  - DATE
  - TIMESTAMP
  - TIME
  - INTERVAL
  - LIST
  - MAP
  - BYTEA
  - INET
  - UUID
- Functions
  Functions
  - Text
    Text
    
    ASCII
    
    CHR
    
    CONCAT
    
    CONCAT_WS
    
    FIND_IDX
    
    INITCAP
    
    LEFT
    
    LOWER
    
    LPAD
    
    LTRIM
    
    MD5
    
    POSITION
    
    REPEAT
    
    REVERSE
    
    RIGHT
    
    RPAD
    
    RTRIM
    
    SUBSTR
    
    TRIM
    
    UPPER
  - Math
    Math
    
    ABS
    
    ACOS
    
    ASIN
    
    ATAN
    
    CEIL
    
    COS
    
    DEGREES
    
    DIV
    
    EXP
    
    FLOOR
    
    GCD
    
    LCM
    
    LN
    
    LOG
    
    LOG10
    
    LOG2
    
    MOD
    
    PI
    
    POWER
    
    RADIANS
    
    RAND
    
    ROUND
    
    SIGN
    
    SIN
    
    SQRT
    
    TAN
    
    TRUNC
  - Date & Time
    Date & Time
    
    ADD_MONTH
    
    EXTRACT
    
    FORMAT
    
    LAST_DAY
    
    NOW
    
    TO_DATE
    
    TO_TIME
    
    TO_TIMESTAMP
  - List & Map
    List & Map
    
    APPEND
    
    CONCAT
    
    DEDUP
    
    ENTRIES
    
    IS_EMPTY
    
    KEYS
    
    LENGTH
    
    PREPEND
    
    SKIP
    
    SLICE
    
    SORT
    
    SQL Function - "SPLICE"
    
    TAKE
    
    VALUES
  - Geometry
    Geometry
    
    CALC_DISTANCE
    
    GET_X
    
    GET_Y
    
    POINT
  - Others
    Others
    
    CAST
    
    COALESCE
    
    GENERATE_UUID
    
    GREATEST
    
    IFNULL
AST Builder
AST Builder
- Introduction
- Statements
  Statements
  - Querying
    Querying
    
    Fetching Data from Storage
    
    Using Preloaded Data
    
    Creating Derived Subqueries
    
    Data Aggregation
    
    Data Injection
    
    Data Joining Data Joining
    On this page
    
    Todo
    
    Data Selection and Projection
    
    Data Sorting and Limiting
  - Data Manipulation
    Data Manipulation
    
    Inserting Data
    
    Updating Data
    
    Deleting Data
- Expressions
  Expressions
- Functions
  Functions
  - Text
    Text
    
    Case Conversion
    
    Character Conversion
    
    Padding
    
    Position and Indexing
    
    Text Manipulation
    
    Trimming
  - Math
    Math
    
    Basic Arithmetic
    
    Conversion
    
    Logarithmic and Exponential
    
    Rounding
    
    Special Mathematical
    
    Trigonometric
  - Date & Time
    Date & Time
    
    Conversion
    
    Current Date and Time
    
    Date and Time Extraction
    
    Formatting
  - List & Map
    List & Map
    
    List and Map Concatenation
    
    List Manipulation
  - Geometry
    Geometry
    
    Coordinate Extraction
    
    Distance Calculation
    
    Point Creation
  - Others
    Others
    
    Null Handling
    
    Type Conversion
    
    Unique Identifier
Storages
Storages
- Introduction
- Supported Storages
  Supported Storages
- Developing Custom Storages
  Developing Custom Storages
  - Introduction
  - Understanding Store traits
    Understanding Store traits
    
    Store
    
    StoreMut
    
    AlterTable
    
    Transaction
    
    CustomFunction
    
    CustomFunctionMut
    
    Index
    
    IndexMut
    
    Metadata
  - Using the Test Suite
Archive
Archive
- Articles
  Articles
- Releases
  Releases

On this page

Todo

Introduction
AST Builder
Statements
Querying

Data Joining¶

Todo¶

- JOIN: Combines rows from two or more tables based on a related column between them.