0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT a.OwnerUserId, b.AcceptedAnswerId 
FROM Posts a
INNER JOIN Posts b 
ON a.AcceptedAnswerId = b.OwnerUserId
WHERE a.AcceptedAnswerId IS NOT NULL
AND b.AcceptedAnswerId IS NOT NULL
AND a.AcceptedAnswerId <> a.OwnerUserId
AND b.AcceptedAnswerId <> b.OwnerUserId;

fork query

edited sep 18 18

created sep 18 18 anonymous