16-10-2007
|
|
Miembro de Oro
|
|
Registrado: may 2006
Ubicación: Santo Domingo, Rep. Dom.
Posts: 3.040
Reputación: 22
|
|
Hola ContraVeneno, Mira lo que me sale:
Cita:
Error
consulta SQL:
SELECT CASACOMERCIAL, FACTURA,
CASE WHEN datediff( FECHAFACTURA, CurDate( ) ) <30
THEN VALOR
ELSE 0
END AS dias30,
CASE WHEN datediff( FECHAFACTURA, Curdate( ) )
BETWEEN 31
AND 45
THEN VALOR
ELSE 0
END AS dias45,
CASE WHEN datediff( FECHAFACTURA, Curdate( ) )
BETWEEN 46
AND 60
THEN VALOR
ELSE 0
END AS dias60,
CASE WHEN datediff( FECHAFACTURA, CurDate( ) ) >60
THEN VALOR
ELSE 0
END AS masdias60,
FROM TABLA2
LIMIT 0 , 30
MySQL ha dicho:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'From TABLA2
LIMIT 0, 30' at line 1
|
Saludos
|