How does wordpress link columns from different tables without using FOREIGN KEY or JOIN?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

SELECT P.Id, P.ParentId, P.OwnerUserId, P.AcceptedAnswerId, P.Score, P.Body, P.CreationDate, C.UserId CommentUserId, C.Text CommentText, C.CreationDate CommentCreationDate, (SELECT Name FROM PostTypes AS PT WHERE PT.Id = P.PostTypeId) PostType FROM Posts AS P FULL OUTER JOIN Comments AS C ON C.PostId = P.Id WHERE P.Id = 419602 OR P.ParentId = 419602

Enter Parameters

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