Compile time warnings

Some compile time warnings occurred. Solutions have been added for these cases, somewhat categorized. 
This looks suspect. Is there a reason we can't pick a join type?