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.

Thanks
Gopi

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?

Thanks,
Neill

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.

Gopi