I have a query who's SQL is working perfectly
It produces FIRSTNAME,LASTNAME, FINAL_LEVEL (a calculated value based on Table1, Table2 and Table3)
I need to create a join onto Table4 with two columns LVL and grade with a join between Query [final_level] and table 4[grade] so that a grade can be added to the original fields.
It has to be done at SQL level I think as I cant access the final_level column in the query builder
Can anyone advise. Tired of trying!