Skip to content

Instantly share code, notes, and snippets.

@shoaibali

shoaibali/intersect.sql

Created June 23, 2016 20:11
Show Gist options
  • Save shoaibali/8324ec68bc5f457db05d1ddba4cdc805 to your computer and use it in GitHub Desktop.
Save shoaibali/8324ec68bc5f457db05d1ddba4cdc805 to your computer and use it in GitHub Desktop.
Download ZIP
INTERSECT of two tables in MySQL database File_dev and File_broken are the two tables
Raw
intersect.sql
SELECT Filename FROM File_dev WHERE Filename NOT IN (SELECT Filename FROM File_broken);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment