CODEWITHSUNDEEP
mysql
Somebody
Somebody

Reputation: 9645

Mysql: DELETE with IN subquery

DELETE FROM images WHERE image_id IN(
    (SELECT i.image_id FROM images i
    LEFT JOIN ads a ON i.ad_id=a.id
        WHERE ISNULL(a.id))
)

I need to accomplish this query. Any help will be appreciated. Thanks ;)

Upvotes: 1

Views: 1293

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135918

DELETE i
    FROM images i
        LEFT JOIN ads a ON i.ad_id=a.id
    WHERE ISNULL(a.id)

Upvotes: 1

Related Questions