I have a table users
which has a primary key userid
and a datetime column pay_date
.
I've also got a table user_actions
which references users
via the column userid
, and a datetime column action_date
.
I want to join the two tables together, fetching only the earliest action from the user_actions
table which has an action_date
later than or equal to pay_date
.
I'm trying things like:
select users.userid from users
left join user_actions on user_actions.userid = users.userid
where user_actions.action_date >= users.pay_date
order by user_actions.pay_date
But obviously that returns me multiple rows per user (one for every user action occurring on or after pay_date
). Any idea where to go from here?
Apologies for what probably seems like a simple question, I'm fairly new to t-sql.