0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

SELECT 
    p.Body AS [Post Content], -- Содержание поста
    (SELECT u.DisplayName FROM Users u WHERE u.Id = p.OwnerUserId) AS [Username] -- Имя пользователя из подзапроса
FROM 
    Posts p -- Таблица постов
WHERE 
    p.OwnerUserId IS NOT NULL; -- Исключаем посты без автора

view current version

edited dec 3

created dec 3 jon.doe46476