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)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

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