empty result when using a subquery select

Use a left join instead. It is faster with many values anyway:

SELECT t1.article 
FROM table1 t1
LEFT JOIN table2 t2 ON t1.article = t2.article
WHERE t2.article IS NULL

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top