FiveTech Software tech support forums

Code: Select all | Expand

DROP TABLE IF EXISTS pruebas ;

CREATE TABLE pruebas  
   SELECT fechemis,td,numdoc,codicont,nombre FROM facturas GROUP BY codicont ;

SELECT * FROM pruebas
WHERE codicont NOT IN (SELECT codicont FROM catalogo WHERE nv = 'S') ;