Method: ROM::SQL::Relation::Reading#join

Defined in:: lib/rom/sql/relation/reading.rb

#join(dataset, join_conditions) ⇒ `Relation` #join(dataset, join_conditions, options) ⇒ `Relation` #join(relation) ⇒ `Relation` #join(relation, &block) ⇒ `Relation` Also known as: inner_join

Join with another relation using INNER JOIN

Overloads:

#join(dataset, join_conditions) ⇒ Relation

Join with another relation using dataset name and join conditions
Examples:
```
users.join(:tasks, id: :user_id)
```
Parameters:
- dataset (Symbol) —
  
  Join table name
- join_conditions (Hash) —
  
  A hash with join conditions
#join(dataset, join_conditions, options) ⇒ Relation

Join with another relation using dataset name and join conditions with additional join options
Examples:
```
users.join(:tasks, { id: :user_id }, { table_alias: :tasks_1 })
```
Parameters:
- dataset (Symbol) —
  
  Join table name
- join_conditions (Hash) —
  
  A hash with join conditions
- options (Hash) —
  
  Additional join options
#join(relation) ⇒ Relation

Join with another relation

Join conditions are automatically set based on schema association
Examples:
```
users.join(tasks)
```
Parameters:
- relation (Relation) —
  
  A relation for join
#join(relation, &block) ⇒ Relation

Join with another relation using DSL
Examples:
```
users.join(tasks) { |users:, tasks:|
  tasks[:user_id].is(users[:id]) & users[:name].is('John')
}
```
Parameters:
- relation (Relation) —
  
  A relation for join

Returns:

(Relation)



595
596
597

# File 'lib/rom/sql/relation/reading.rb', line 595

def join(...)
  __join__(__method__, ...)
end