Efficient table comarison : What is the best way to find way to select values present in one table but not in other - left join,not in or not exists.  
There probably isn't a universal answer - so would appreciate the used-case where each is advisable.
