Error sentencia Base de datos
Publicado por Juan (16 intervenciones) el 02/05/2018 17:49:58
Buenas tardes , he hecho una sentencia SQL y a la hora de poner la consulta en el Ireport , me sale el siguiente error:
Error:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcention: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "FIRSTNAME" AS ADDRESS_FIRSTNAME, ADDRESS."LASTNAME" AS ADDRESS_LAST NAME,' at line 3
Les dejo mi sentencia sql por aqui:
Muchas gracias de antemano
Error:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcention: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "FIRSTNAME" AS ADDRESS_FIRSTNAME, ADDRESS."LASTNAME" AS ADDRESS_LAST NAME,' at line 3
Les dejo mi sentencia sql por aqui:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SELECT
ADDRESS."FIRSTNAME" AS ADDRESS_FIRSTNAME,
ADDRESS."LASTNAME" AS ADDRESS_LASTNAME,
ADDRESS."STREET" AS ADDRESS_STREET,
ADDRESS."CITY" AS ADDRESS_CITY,
POSITIONS."QUANTITY" AS POSITIONS_QUANTITY,
POSITIONS."PRICE" AS POSITIONS_PRICE,
PRODUCT."NAME" AS PRODUCT_NAME,
ADDRESS."ID" AS ADDRESS_ID,
DOCUMENT."ID" AS DOCUMENT_ID,
POSITIONS."QUANTITY" * POSITIONS."PRICE" AS total
FROM
"PUBLIC"."ADDRESS" ADDRESS,
"PUBLIC"."DOCUMENT" DOCUMENT,
"PUBLIC"."POSITIONS" POSITIONS,
"PUBLIC"."PRODUCT" PRODUCT
WHERE
Document.addressid = Address.id
AND Positions.documentid = document.id
AND positions.productid = product.id
ORDER BY
ADDRESS."ID" ASC,
DOCUMENT."ID" ASC
Muchas gracias de antemano
Valora esta pregunta
0