Advertisement
Guest User

Untitled

a guest
Dec 11th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. batch semester scode
  2. 1 6 DA
  3. 1 6 IA
  4. 1 6 FA
  5.  
  6. batch subject
  7. 1 DA
  8.  
  9. scode
  10. IA
  11. FA
  12.  
  13. SELECT
  14. scode
  15. FROM TABLE1 T1
  16. WHERE NOT EXISTS (
  17. SELECT 1 FROM TABLE2 T2 WHERE T1.scode = T2.subject
  18. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement