Inner Join TOP 1 Value

Yep. Didn't get the results i wanted.

I made it the messy way, which was to put the entire inner join select statement, into the select statement on the first prompt. That way, I can put the WHERE restriction clause using job number