Código SQL [-]SELECT a.FACT,a.PDTO, a.UNDS, b.CONSI FROM PRODUCCION a Inner Join MESRC b On(a.FACT=b.FACTU) where b.CONSI = (select first 1 c.CONSI from MESRC c where c.FACTU = a.FACT);
SELECT a.FACT,a.PDTO, a.UNDS, b.CONSI FROM PRODUCCION a Inner Join MESRC b On(a.FACT=b.FACTU) where b.CONSI = (select first 1 c.CONSI from MESRC c where c.FACTU = a.FACT);