**Summary** Description for this feature. The difference between `left any join` and `left join` is that, the former one will only match a single row for the right table