error en consulta con iif

[vpino]

buen dia

con este me muestra un registros

Código SQL:

SELECT  DISTINCT f200_nit,    f200_razon_social,   '' AS Macrozona,   '' AS Zona, '' AS SubZona,'' AS Canal
FROM t461_cm_docto_factura_venta 
INNER JOIN (t207_mm_criterios_clientes INNER JOIN t206_mm_criterios_mayores ON (f207_id_cia=f206_id_cia AND f207_id_plan_criterios=f206_id_plan AND f207_id_criterio_mayor=f206_id  AND  (f206_id_plan= 001 OR f206_id_plan= 002 OR f206_id_plan= 003 OR f206_id_plan= 004))) ON (f461_rowid_tercero_fact=f207_rowid_tercero AND f461_id_sucursal_fact=f207_id_sucursal AND f461_id_cia=f207_id_cia)
INNER JOIN  t201_mm_clientes ON (f461_rowid_tercero_fact=f201_rowid_tercero AND f461_id_sucursal_fact=f201_id_sucursal)
INNER JOIN t200_mm_terceros ON (f200_rowid=f201_rowid_tercero AND f200_id_cia=f201_id_cia)
WHERE f461_id_fecha BETWEEN '01/06/2015' AND '01/06/2015'
AND (f200_nit LIKE '80185344%')
 

y con este me muestra cuatro registros

Código SQL:

SELECT  DISTINCT f200_nit,    f200_razon_social,   iif (f207_id_plan_criterios= 001, f206_descripcion,'') AS Macrozona,     iif (f207_id_plan_criterios= 002, f206_descripcion,'') AS Zona, iif (f207_id_plan_criterios= 003, f206_descripcion,'') AS SubZona,iif (f207_id_plan_criterios= 004, f206_descripcion,'') AS Canal
FROM t461_cm_docto_factura_venta 
INNER JOIN (t207_mm_criterios_clientes INNER JOIN t206_mm_criterios_mayores ON (f207_id_cia=f206_id_cia AND f207_id_plan_criterios=f206_id_plan AND f207_id_criterio_mayor=f206_id  AND  (f206_id_plan= 001 OR f206_id_plan= 002 OR f206_id_plan= 003 OR f206_id_plan= 004))) ON (f461_rowid_tercero_fact=f207_rowid_tercero AND f461_id_sucursal_fact=f207_id_sucursal AND f461_id_cia=f207_id_cia)
INNER JOIN  t201_mm_clientes ON (f461_rowid_tercero_fact=f201_rowid_tercero AND f461_id_sucursal_fact=f201_id_sucursal)
INNER JOIN t200_mm_terceros ON (f200_rowid=f201_rowid_tercero AND f200_id_cia=f201_id_cia)
WHERE f461_id_fecha BETWEEN '01/06/2015' AND '01/06/2015'
AND (f200_nit LIKE '80185344%')