Como puedo borrar lo que esta dentro de este SELECT ?

SELECT node_revision.nid, node_revision.vid, node_revision.uid, node_revision.title, node_revision.log, node_revision.timestamp, node_revision.status, node_revision.comment, node_revision.promote, node_revision.sticky, node_revision.vuuid FROM 
node_revision AS node_revision
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Vittey dijo:

Seria algo asi
DELETE campos
From tabla
y demas sentencias.

Hacer clic para expandir...

blogers dijo:

Es que es un JOIN lo ando compactando asi

PHP:

SELECT node_revision.nid, node_revision.vid, node_revision.uid, node_revision.title, node_revision.log, node_revision.timestamp, node_revision.status, node_revision.comment, node_revision.promote, node_revision.sticky, node_revision.vuuid FROM 
node_revision AS node_revision
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Hacer clic para expandir...

SELECT *
 FROM 
node_revision 
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

DELETE  FROM node_revision   JOIN (SELECT *
 FROM 
node_revision 
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) )) 

);

Vittey dijo:

Lo has intentado al menos ?
puedes intentar usando una subconsulta.

Hacer clic para expandir...

blogers dijo:

PHP:

SELECT *
 

);

Me sale error

Hacer clic para expandir...

DELETE  node_revision
 FROM 
node_revision 
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Vittey dijo:

veo que andas mal con la sub consulta.
Intenta, primero, eliminar sin join.
O hacer una subconsulta, sin usar join, y eliminar
paso seguido, intenta con join, por ahi tienes el problema.

Hacer clic para expandir...