Inner Join TOP 1 Value

Try the CTE approach:

You can define multiple CTE-s at the beginning of the query.

---

Tried the CTE approach, but can't get the assignment of the JobNumber to the returned JobNumber results.