Left join : Map to SQL « ActiveRecord « Ruby

1.	ActiveRecord
2.	Array
3.	CGI
4.	Class
5.	Collections
6.	Database
7.	Date
8.	Design Patterns
9.	Development
10.	File Directory
11.	GUI
12.	Hash
13.	Language Basics
14.	Method
15.	Network
16.	Number
17.	Rails
18.	Range
19.	Reflection
20.	Statement
21.	String
22.	Threads
23.	Time
24.	Tk
25.	Unit Test
26.	Windows Platform
27.	XML

Ruby » ActiveRecord » Map to SQL

Left join





Account.find :all,

             :joins => "LEFT JOIN visits ON accounts.id=visits.account"



The result will be the following SQL query:



SELECT * FROM accounts LEFT JOIN visits ON accounts.id=visits.account_id

Related examples in the same category

1.	The :order parameter defines the sorting order.
2.	Group by clause
3.	Aggregate function and group by
4.	Left join on a column
5.	Limit offset

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.