Ayuda Urgente en Consulta SQL
Publicado por alejandro (1 intervención) el 07/01/2005 19:26:01
Hola a Todos los del foro, trabajo en VB6.0 con Access97, el problema q tengo es q la sentencia sql q tengo en basic me devuelve registros menores a cuando ejecuto la misma sentencia en Access, por ej. en basic el recordset q ejecuta la sentencia me devuelve 216 registros, y cuando ejecuto la misma sentencia en access me devuelve 218(la cual es lo correcto), la sentencia q tengo esta en base a filtros de Mes y fecha, y esto solo pasa en un mes, en los demas esta todo correcto, les adjunto mi sentencia para q la revisen y me den una ayudita. Se los agradeceria bastante. Saludos.
SELECT ID as Número_Despacho, SHIPTO_ADDR_ETC as Número_Guía_Impresa, INVOICE_ID as Número_Factura_Impresa,SHIPPED_DATE as Fecha_Despacho, NAME as Cliente, (SHIPTO_ADDR_1 & " " & SHIPTO_ADDR_2 & " " & SHIPTO_CITY & " - " & SHIPTO_STATE) as DirecciónDespacho, SHIPPED_AMOUNT as Sub_Total, (SUM(T.TAX_AMOUNT)) AS IMPUESTO, (SHIPPED_AMOUNT+(SUM(T.TAX_AMOUNT))) as Total
FROM SALES_SHIPPER AS S LEFT OUTER JOIN SALES_SHIPPER_TAX AS T ON S.ID=T.SHIPPER_ID
WHERE ID<>'' AND ISNULL(TRIM(INVOICE_ID)) AND SHIPPER_STATUS='APPROVED' AND SHIPPER_TYPE='SHIPMENT' AND Month(SHIPPED_DATE)= '12' AND YEAR(SHIPPED_DATE)='2004' GROUP BY ID,SHIPTO_ADDR_ETC, INVOICE_ID, SHIPPED_DATE, NAME, SHIPTO_ADDR_1 & " " & SHIPTO_ADDR_2 & " " & SHIPTO_CITY & " - " & SHIPTO_STATE,SHIPPED_AMOUNT
SELECT ID as Número_Despacho, SHIPTO_ADDR_ETC as Número_Guía_Impresa, INVOICE_ID as Número_Factura_Impresa,SHIPPED_DATE as Fecha_Despacho, NAME as Cliente, (SHIPTO_ADDR_1 & " " & SHIPTO_ADDR_2 & " " & SHIPTO_CITY & " - " & SHIPTO_STATE) as DirecciónDespacho, SHIPPED_AMOUNT as Sub_Total, (SUM(T.TAX_AMOUNT)) AS IMPUESTO, (SHIPPED_AMOUNT+(SUM(T.TAX_AMOUNT))) as Total
FROM SALES_SHIPPER AS S LEFT OUTER JOIN SALES_SHIPPER_TAX AS T ON S.ID=T.SHIPPER_ID
WHERE ID<>'' AND ISNULL(TRIM(INVOICE_ID)) AND SHIPPER_STATUS='APPROVED' AND SHIPPER_TYPE='SHIPMENT' AND Month(SHIPPED_DATE)= '12' AND YEAR(SHIPPED_DATE)='2004' GROUP BY ID,SHIPTO_ADDR_ETC, INVOICE_ID, SHIPPED_DATE, NAME, SHIPTO_ADDR_1 & " " & SHIPTO_ADDR_2 & " " & SHIPTO_CITY & " - " & SHIPTO_STATE,SHIPPED_AMOUNT
Valora esta pregunta


0