saleks28

Untitled

Oct 13th, 2020
320
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.29 KB | None | 0 0
  1. SELECT Applications.Code
  2. FROM Applications
  3. WHERE NOT EXISTS
  4. (SELECT * FROM (SELECT *
  5. FROM
  6.     (SELECT Applications.Code Code_App, SystemSoft.Code Code_SystemSoft
  7.     FROM SystemSoft CROSS JOIN Applications)
  8. MINUS
  9.     SELECT * FROM Applications_SystemSoft) WHERE Code_App=Applications.Code);
  10.  
Add Comment
Please, Sign In to add comment