SQL ERROR when i try to do a delete from using 2 tables

Question

I'm using MariaDB. Im trying to do a delete using this two tables:

Table LINPED:

CREATE TABLE LINPED (
    NUMPEDIDO SMALLINT NOT NULL,
    NUMLINEA SMALLINT NOT NULL,
    NUMPIEZA CHAR(16),
    PRECIOCOMPRA INTEGER,
    CANTPEDIDA SMALLINT,
    FECHARECEP datetime,
    CANTRECIBIDA SMALLINT);

Table PEDIDO:

CREATE TABLE PEDIDO (
    NUMPEDIDO SMALLINT NOT NULL,
    NUMVEND SMALLINT,
    FECHA datetime);

At first i try to do that:

DELETE FROM LINPED
INNER JOIN PEDIDO 
ON LINPED.NUMPEDIDO = PEDIDO.NUMPEDIDO
WHERE PEDIDO.NUMVEND= 1 AND PEDIDO.NUMPEDIDO= 1

But it not works for me because i get this error:

[Window Title] sesion1: Error

[Content] Error de SQL (1064): 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 'INNER JOIN PEDIDO ON LINPED.NUMPEDIDO = PEDIDO.NUMPEDIDO WHERE numven' at line 2

[Aceptar]

[Footer] Encontrar ayuda acerca de este error

Searching for a solution in Stackoverfolw I found one similar question with this solution:

DELETE FROM LINPED
JOIN PEDIDO ON LINPED.NUMPEDIDO = PEDIDO.NUMPEDIDO
WHERE PEDIDO.NUMVEND = 1 AND PEDIDO.NUMPEDIDO = 1

But it not works, at least for me

[Window Title] sesion1: Error

[Content] Error de SQL (1064): 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 'JOIN PEDIDO ON LINPED.NUMPEDIDO = PEDIDO.NUMPEDIDO WHERE PEDIDO.NUMVEND = 1 AND' at line 2

[Aceptar]

[Footer] Encontrar ayuda acerca de este error

Instead of DELETE FROM LINPED ..., try DELETE LINPED FROM LINPED ... — sstan
– sstan, Commented Jan 1, 2018 at 21:04

Kostas Mitsarakis · Accepted Answer · 2018-01-01 20:59:27Z

1

Delete from LINPED table explicitly using the following:

DELETE l.*
FROM LINPED AS l
INNER JOIN PEDIDO AS p
ON l.NUMPEDIDO = p.NUMPEDIDO
WHERE p.NUMVEND = 1 AND p.NUMPEDIDO = 1

answered Jan 1, 2018 at 20:59

Kostas Mitsarakis

4,7473 gold badges26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL ERROR when i try to do a delete from using 2 tables

But it not works for me because i get this error:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

But it not works for me because i get this error:

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related