Recently i was working on a project and found a new way to take an inner join.
here we goes
from account a, accountstatus acs
and acs.account_num = a.account_num
and acs.effective_dtm =
where account_num = acs.account_num)
this will fetch the information from the account table based on the latest information (which is date in this case) from the accountstatus table