Cómo hacer un reporte de productos que nunca se vendierón?
121 views
Skip to first unread message
Wilzy G
unread,
Oct 21, 2016, 6:23:08 PM10/21/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
Hola a todos. Una pregunta:
'Cómo puedo hacer un reporte que muestre todos los productos que NUNCA SE VENDIERÓN (ni 1 sola venta)?? Estoy tratando con una subconsulta, pero no me funciona.
SELECT cod_producto,descripcion FROM productos WHERE cod_producto NOT in (SELECT cod_producto DISTINCT FROM detalle_factura_cliente)
TABLAS:
* Productos
- cod_producto - cod_barras - descripcion - cantidad_stock - bla bla bla
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
Como es VIERNES tengo la Respuesta correcta.
Abre el Almacén y si vez varias cosas que no se han movido y estan en el mismo lugar, esos son los productos que nunca se vendieron,
Germán Fabricio Valdez
unread,
Oct 21, 2016, 7:20:26 PM10/21/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
saca el DISTINCT
Wilzy G
unread,
Oct 21, 2016, 8:38:47 PM10/21/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
Muchas gracias German, me salvaste de tener que utilizar el método de Jean Pierre XD
Oscar Quiros Coto
unread,
Oct 24, 2016, 2:57:05 PM10/24/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
Prueba de esta otra forma
Debe ser mas rapido que la consulta con un sub-select.
SELECT A.cod_producto,A.descripcion
FROM productos A
LEFT JOIN detalle_factura_cliente B ON A.cod_producto=B.cod_producto
WHERE b.cantidad IS NULL
Wilzy G
unread,
Oct 25, 2016, 5:17:07 PM10/25/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
Excelente. Muchas Gracias.
panchimancuso
unread,
Oct 26, 2016, 8:47:07 AM10/26/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
jeje este jean pierre me hizo reir jeje
prueba asi
SELECT cod_producto as codigo ,descripcion as detalle FROM productos WHERE codigo NOT in (SELECT cod_producto as codigo fROM detalle_factura_cliente) into cursor tmp
Wilzy G
unread,
Oct 27, 2016, 8:54:36 AM10/27/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Comunidad de Visual Foxpro en Español
Gracias a todos, he probado todos los códigos y todos funcionan.