Subselect a la misma tabla

[gnzsoloyo]

Prueba con:

Código MySQL:

SELECT 
    A1.CODIGOART CODIGOV,
    A1.DESCRIP,
    A1.STOCK,
    A1.CODIGOARTNUEVO CODIGON,
    IFNULL(A2.STOCK, '') STOCK2
FROM ARTICULO A1 LEFT JOIN ARTICULO A2 ON A1.CODIGOART = A2.CODIGON
WHERE 
    A1.STOCK >= 1 
    AND (A1.CODIGOARTNUEVO IS NOT NULL OR A2.CODIGOARTNUEVO IS NOT NULL)
    AND (A1.CODIGOARTNUEVO NOT IN('', '1') OR A2.CODIGOARTNUEVO NOT IN('', '1'));