Hi @keshav_m. Is the issue of the LEFT OUTER JOIN addressed in this documentation?
LEFT OUTER JOIN
See: