Replace NOT IN with JOIN

Example of how to replace NOT IN clause with JOIN