Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Author(AutorID INT, Name VARCHAR(50));
- CREATE TABLE Article(ArticleID INT, Article VARCHAR(MAX),Author VARCHAR(50));
- SELECT DISTINCT Article.Author WHERE Article.Author NOT IN
- (SELECT Author.Name FROM Author) AND Article.Author IS NOT NULL
- AND Article.Author != '';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement