module

Clear::SQL::Query::Join

Instance methods

cross_join(name : Selectable, lateral = false)

full_outer_join(name : Selectable, lateral = false, &)

Add a "FULL_OUTER" JOIN directive to the query

full_outer_join(name : Selectable, condition : String = "true", lateral = false)

Add a "FULL_OUTER" JOIN directive to the query

inner_join(name : Selectable, lateral = false, &)

Add a "INNER" JOIN directive to the query

inner_join(name : Selectable, condition : String = "true", lateral = false)

Add a "INNER" JOIN directive to the query

join(name : Selectable, type = :inner, lateral = false, &)

join(name : Selectable, type = :inner, condition : String = "true", lateral = false)

join(name : Selectable, type = :inner, lateral = false)

left_join(name : Selectable, lateral = false, &)

Add a "LEFT" JOIN directive to the query

left_join(name : Selectable, condition : String = "true", lateral = false)

Add a "LEFT" JOIN directive to the query

right_join(name : Selectable, lateral = false, &)

Add a "RIGHT" JOIN directive to the query

right_join(name : Selectable, condition : String = "true", lateral = false)

Add a "RIGHT" JOIN directive to the query