module Clear::SQL::Query::Join

Direct including types

Defined in:

clear/sql/query/join.cr

Instance Method Summary

Instance Method Detail

def cross_join(name : Selectable, lateral = false) #

[View source]
def full_outer_join(name : Selectable, lateral = false, &) #

Add a "FULL_OUTER" JOIN directive to the query


[View source]
def full_outer_join(name : Selectable, condition : String = "true", lateral = false) #

Add a "FULL_OUTER" JOIN directive to the query


[View source]
def inner_join(name : Selectable, lateral = false, &) #

Add a "INNER" JOIN directive to the query


[View source]
def inner_join(name : Selectable, condition : String = "true", lateral = false) #

Add a "INNER" JOIN directive to the query


[View source]
def join(name : Selectable, type = :inner, lateral = false, &) #

[View source]
def join(name : Selectable, type = :inner, condition : String = "true", lateral = false) #

[View source]
def join(name : Selectable, type = :inner, lateral = false) #

[View source]
def left_join(name : Selectable, lateral = false, &) #

Add a "LEFT" JOIN directive to the query


[View source]
def left_join(name : Selectable, condition : String = "true", lateral = false) #

Add a "LEFT" JOIN directive to the query


[View source]
def right_join(name : Selectable, lateral = false, &) #

Add a "RIGHT" JOIN directive to the query


[View source]
def right_join(name : Selectable, condition : String = "true", lateral = false) #

Add a "RIGHT" JOIN directive to the query


[View source]