LEFT JOIN With Additional Filter Value
I'm trying to replicate the below left join in a GI by adding the additional filter at the end of the join. Is there any way to achieve this in a GI? I was trying to add a field outright in the relation and was hoping I could just add a value in the child field section but it complains with any variation I try. I tried another way doing it in the conditions but that didn't work out. Thanks in advance for any help on this.
LEFT JOIN FSGeoZone ON FSGeoZonePostalCode.GeoZoneID=FSGeoZone.GeoZoneID AND FSGeoZone.AreaType = 200