I am attempting to build a query that will grab values from 2 tables that are related through a junction table. I’ve included a screenshot of the tables in question. (apparently cannot embed pictures yet, first post!) https://i.stack.imgur.com/Ru9qJ.png In my query I need all the fields from worker and the NEWEST LMIA.lmia_number. The issue I am running […]