StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9833133
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-03-23T01:51:48.873
FavoriteCount
0
LastActivityDate
2012-03-23T02:10:20.897
LastEditDate
2012-03-23T02:10:20.897
LastEditorUserId
1216612
OwnerUserId
1216612
ParentId
9833056
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You can select the individual Ids who answered one of the questions, like this: <pre><code>select distinct memberId where answerId = 'dogs' select distinct memberId where answerId = 'red' </code></pre> Then replace the ands with inner joins, like this: <pre><code>select memberId from (select distinct memberId where answerId = 'dogs') D inner join (select distinct memberId where answerId = 'red') R on D.MemberId = R.memberId </code></pre> And replace the OR with UNION, like this: <pre><code>select memberId from (select distinct memberId where answerId = 'dogs') D inner join (select distinct memberId where answerId = 'red') R on D.MemberId = R.memberId union select memberId from (select distinct memberId where answerId = 'cats') D inner join (select distinct memberId where answerId = 'green') R on D.MemberId = R.memberId </code></pre> This is exactly, as you say, a "set sintax": <pre><code>Set: each indivdual select Intersection of sets : inner join Union of sets: union </code></pre> If you need extra conditions, for example checking only answers 1 and 2, you can use a CTE with the common conditions like "answerId in (1,2)" to avoid writing this same condition in every select, making the sintax more clear. You can also use this sintax, which is more similar to your original writing: <pre><code>select memberId from members M where ( exists (select 1 from answers where answerId='dogs' and memberId=M.member Id) and exists (select 1 from answers where answerId='red' and memberId=M.member Id) ) or ( exists (select 1 from answers where answerId='cats' and memberId=M.member Id) and exists (select 1 from answers where answerId='green' and memberId=M.member Id) ) -- I select 1 instead of * or any column for performance reasons </code></pre> I leave out the details of adding extra checks (answerId and so on) to make it easier to understand.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSQL: conditioning multiple rows on an inner joined table
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJotaBe
UserOwnerUserId
1. USJotaBe
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POSQL: conditioning multiple rows on an inner joined table
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThanks for this, well I'm going to be doing a lot of code rewriting this weekend :( (My SQL query generation.)
 singulars
 PostPostId
 PO
 UserUserId
 USNeaox

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.