File: //usr/local/rvm/gems/ruby-2.5.9/doc/activerecord-6.1.4.1/ri/ActiveRecord/QueryMethods/joins-i.ri
U:RDoc::AnyMethod[iI"
joins:ETI"%ActiveRecord::QueryMethods#joins;TF:publico:RDoc::Markup::Document:@parts[o:RDoc::Markup::Paragraph; [I"NPerforms a joins on +args+. The given symbol(s) should match the name of ;TI"the association(s).;To:RDoc::Markup::BlankLine o:RDoc::Markup::Verbatim; [ I"User.joins(:posts)
;TI"# SELECT "users".*
;TI"# FROM "users"
;TI"># INNER JOIN "posts" ON "posts"."user_id" = "users"."id"
;T:@format0o;
; [I"Multiple joins:;T@o;; [
I""User.joins(:posts, :account)
;TI"# SELECT "users".*
;TI"# FROM "users"
;TI"># INNER JOIN "posts" ON "posts"."user_id" = "users"."id"
;TI"G# INNER JOIN "accounts" ON "accounts"."id" = "users"."account_id"
;T;
0o;
; [I"Nested joins:;T@o;; [
I"$User.joins(posts: [:comments])
;TI"# SELECT "users".*
;TI"# FROM "users"
;TI"># INNER JOIN "posts" ON "posts"."user_id" = "users"."id"
;TI"D# INNER JOIN "comments" ON "comments"."post_id" = "posts"."id"
;T;
0o;
; [I":You can use strings in order to customize your joins:;T@o;; [I"pUser.joins("LEFT JOIN bookmarks ON bookmarks.bookmarkable_type = 'Post' AND bookmarks.user_id = users.id")
;TI"|# SELECT "users".* FROM "users" LEFT JOIN bookmarks ON bookmarks.bookmarkable_type = 'Post' AND bookmarks.user_id = users.id;T;
0:
@fileI"0lib/active_record/relation/query_methods.rb;T:0@omit_headings_from_table_of_contents_below000[ I"(*args);T@1FI"QueryMethods;TcRDoc::NormalModule00