Well we're getting there, unfortunately isnull only replaces it if it returns NULL, which this just doesn't return a row. I do however think I can use a view for...

This is close, however I had to join in the order detail table as well, since orders can have multiple items. Also it only shows job codes that actually purchased...

I'm essentially looking to get a query that shows all of the job codes regardless of any purchases. I'll give it a shot but I don't think that one will...