Advertisement
Guest User

Untitled

a guest
May 4th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. CREATE TABLE Author(AutorID INT, Name VARCHAR(50));
  2. CREATE TABLE Article(ArticleID INT, Article VARCHAR(MAX),Author VARCHAR(50));
  3.  
  4. SELECT DISTINCT Article.Author WHERE Article.Author NOT IN
  5. (SELECT Author.Name FROM Author) AND Article.Author IS NOT NULL
  6. AND Article.Author != '';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement