SELECT Users.ID AS 'userid', Users.DisplayName, Posts.ID ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Constructed Languages

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

SELECT Users.ID AS 'userid', Users.DisplayName, Posts.ID AS 'postid'
FROM Users, Posts
WHERE Posts.OwnerUserId = Users.Id AND Users.DisplayName = 'Andy'
ORDER BY userid;

Enter Parameters

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