SELECT p.Id, p.Title, p.Body, a.Body, p.Tags FROM Posts p...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT p.Id, p.Title, p.Body, a.Body, p.Tags
FROM Posts p
JOIN Posts a ON p.AcceptedAnswerId = a.Id
WHERE p.PostTypeId = 1
AND p.Score >= 20
and p.AcceptedAnswerId IS NOT NULL
and p.Tags like '%java%'
and p.Body like '%compatible%';

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results