Skip to content

Instantly share code, notes, and snippets.

@dodangquan

dodangquan/Tìm môn học chưa có người đăng ký.sql

Created August 9, 2015 06:50
Show Gist options
  • Save dodangquan/3a5cf68009e3731c25b5 to your computer and use it in GitHub Desktop.
Save dodangquan/3a5cf68009e3731c25b5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Tìm môn học chưa có người đăng ký.sql
SELECT * FROM [Mon Hoc]
WHERE [Ma Mon Hoc] NOT IN (
SELECT DISTINCT [Ma Mon Hoc] FROM [Bang Dang Ky]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment