0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- таблица с сопоставление пользователей и их заросов
/*
select top 20 * 
  from users u
  left join posts p on u.id = p.owneruserid
*/
-- найдем пользователя, не написавшего ни одного вопроса

select * 
  from users 
  where id not in (
    select owneruserid 
      from posts
      where owneruserid is not null
  )

fork query

edited oct 22 anonymous

created oct 7 jon.doe37112