I want to make two table aliases in my query with left join like the below query.
SELECT * FROM user AS u LEFT JOIN user_group AS ug
@users = User.left_outer_joins(:user_group)
Yes you can
@users = User.joins("LEFT JOIN user_group as ug ON ug.user_id = users.id")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With