SQLite and Right Joins or Outer Joins Alternatives

During my quest to get more acquainted with NodeJS and SQLite, I ran into this error message:

{“status”:“500”,“code”:“SQLITE_ERROR”,“message”:“select profile.* from profile right join login on login.login_id = profile.login_id order by profile.last_name ASC, profile.first_name ASC - SQLITE_ERROR: RIGHT and FULL OUTER JOINs are not currently supported”,“stack”:“Error: select profile.* from profile right join login on login.login_id = profile.login_id order by profile.last_name ASC, profile.first_name ASC - SQLITE_ERROR: RIGHT and FULL OUTER JOINs are not currently supported”}

Are there any other ways to circumvent this when using foreign keys and joins? Or should I just avoid using this MySQL method?

Thank you for your input or suggestions…