Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT author_obj->>'$.name' FROM author WHERE author_obj->'$.name' NOT IN
- (SELECT DISTINCT author_obj->'$.name'
- FROM response INNER JOIN author ON response.author_id = author.id
- WHERE response.parent IS NOT NULL
- GROUP BY author.id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement