LEFT JOIN with more than one Column

Hi Team,

We are trying a query with more than one column in the join on statement. We couldn’t make it work. Is there a restriction on using more than one column in the left/right join? If there is any workaround to make it work.


Hi Gopi,

Welcome to the community. Can you please elaborate further on the challenge you’re experiencing, specifically what error or errors you experienced while attempting to LEFT join using more than one column?


Hi Neil,

It’s working as expected. I’m doing some research on errors reported by my business team. Once done will get back to you.