Error: subquery returning more than one result

Question

Given the sql:

DELETE FROM wgcartarmazens
 WHERE (
   SELECT artigo 
     FROM wgcartarmazens as T 
    INNER JOIN wgcartigos as A ON A.CODIGO=T.ARTIGO
    WHERE T.lote='' AND A.TEMLOTE<>0
 );

The above query returns me the following error

subquery Returns more than 1 value this is not permitted when the subquery Follows

How can I correct?

Answer 1

If you want to make a DELETE in all fields of the subquery, do so:

DELETE FROM wgcartarmazens
 WHERE artigo IN (
   SELECT artigo 
     FROM wgcartarmazens as T 
     JOIN wgcartigos as A ON A.CODIGO = T.ARTIGO
    WHERE T.lote = ''
      AND A.TEMLOTE <> 0
 );