select
    *
from
    @Users u
    outer apply
    (
        select top 1
            *
        from
            @userLogins ul
        where
            u.userId = ul.userId
        order by
            ul.loginDate desc
    )last_login;