SELECT a.clicod as cliente, a.clinom as descripcion, cant_a_sum(b.cabtotal,b.cabbasico) as importe1 ; FROM clientes as a, cabezal as b ; WHERE (a.clicod = b.clicod) AND (b.cabanulado <> 1) AND (incluye_vta(b.cabbasico)) ; AND (b.cabfecha >= dfecini1) AND (b.cabfecha <= dfecfin1) INTO TABLE _sql12)2do. periodo (dfecini2,dfecfin2)
SELECT a.clicod as cliente, a.clinom as descripcion, cant_a_sum(b.cabtotal,b.cabbasico) as importe2 ; FROM clientes as a, cabezal as b ; WHERE (a.clicod = b.clicod) AND (b.cabanulado <> 1) AND (incluye_vta(b.cabbasico)) ; AND (b.cabfecha >= dfecini2) AND (b.cabfecha <= dfecfin2) INTO TABLE _sql23) Consulta final (nporcen se pide al usuario)
SELECT a.*,b.importe2, calc_porcen(a.importe1,b.importe2) as porcen FROM _sql1 as a, _sql2 as b ; WHERE (b.cliente = a.cliente) having (porcen > nporcen) ORDER BY porcen INTO TABLE _resulEstoy apremiado de tiempo por eso lo hice así busque en el manual de SQL pero no encontre una forma sencilla de realizar esto.