SQL join ruby on rails -

SQL join ruby on rails -

so have 2 different models 1 called numbers structured

t.string :number t.date :texted t.integer :times t.timestamps

and 1 called users (i included relevant portion)

t.string :phone_number t.timestamps

what need grab numbers texted date more 2 weeks ago , times less 4 , t.string :number not equal t.string :phone_number in users table. need sort of sql bring together accomplish this?

this have far:

numbers = onumber.where("texted <= ? , times<=4",2.week.ago.utc)

yes left join more suitable here:

onumber.joins( 'left bring together users on onumbers.number = users.phone_number' ).where( 'users.phone_number null , onumber.times <= 4 , onumber.texted < ?', 2.weeks.ago.utc )

this give numbers not in users.phone_number, texted times value less or equal 4.

sql ruby-on-rails ruby ruby-on-rails-4