module Clear::SQL::Query::Join

Direct including types

• Clear::SQL::SelectBuilder

Defined in:

clear/sql/query/join.cr

Instance Method Summary

• #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

Instance Method Detail