Skip to content

Instantly share code, notes, and snippets.

@DriesS

DriesS/sql_join.rb

Last active August 29, 2015 13:56
Show Gist options
  • Save DriesS/9268810 to your computer and use it in GitHub Desktop.
Save DriesS/9268810 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_join.rb
StockTransaction.joins("LEFT JOIN line_items ON line_items.id = stock_transactions.source_id and source_type = 'LineItem'")
.joins(:product)
.where("stock_transactions.cause = 'SALE'")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment