Removed unecessary else.
Enforce uniqueness by DBMS.
Added spec for unhappy #join path.