A simple man's solution that will run faster that I use if your indexes are not speeding up the process is to do a left join as follows and create...