How to efficiently lookup joining table and sort by that data

I’d also recommend potentially creating an index that could be used when joining the tables. That is if this is a key part of what you are doing and/or you regularly are searching for the field that you would index in your app.