Tax Employee Card/ Economic Zone
I'm trying to pull the Economic Zones for Mexico, but it seems that the query I'm using is only returning one single value as "A" where other values should be found as well (e.g 'Zone B (Source: TRU-CD JUAREZ CHI Reg Pat AZ').
and ri.value_Defn_id = vd.value_Defn_id
and vd.legislation_code = ´MX'
source_id is showing empty for Mexico employees, so there's no way to use a join for this field.