Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.nomProd, p.codProd, COUNT(ip.CodProd) FROM Productos p, ImpoProd ip
- WHERE
- ip.codProd = p.codProd
- GROUP BY p.nomProd, p.codProd, ip.codProd
- HAVING COUNT(ip.codProd) =
- (SELECT MIN(CANTIDAD) FROM
- (SELECT ip2.codProd, count(ip2.codProd) AS CANTIDAD
- FROM ImpoProd ip2
- GROUP BY ip2.codProd
- )
- );
Add Comment
Please, Sign In to add comment