Optimization Bans. Works through a Left Join.