StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to get data with multiple references to single table
primarykey
Id
17718084
data
AcceptedAnswerId
17718293
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-18T08:13:13.603
FavoriteCount
0
LastActivityDate
2017-07-06T22:33:13.600
LastEditDate
2017-07-06T22:33:13.600
LastEditorUserId
4370109
OwnerUserId
1808842
ParentId
0
PostTypeId
1
Score
1
ViewCount
137
LastEditorDisplayName
text
Body
I have <code>Image</code> table with 3 columns: <code>Id</code>, <code>Name</code>, and <code>RefId</code> - It will contain <code>Id</code> from other table (with this example is <code>Category</code> table and <code>Product</code> table). <code>Category</code> table with 3 columns: <code>Id</code>, <code>Name</code> and <code>ProductId</code>. <code>Product</code> table includes 3 columns: <code>Id</code>, <code>Name</code>. This is Product's data: <pre><code>Id Name 659543D6-1A0D-4151-B94C-F44CCDA752B5 Product1 5C1A5A2F-4579-41D2-8FAE-93EF71451285 Product2 2C35A651-1681-4E5E-9F0C-315169BDFA1D Product3 </code></pre> And <code>Category</code>'s data: <pre><code>Id Name ProductId F3FFF612-1D6D-4447-B472-2486C4893CDD Category1 659543D6-1A0D-4151-B94C-F44CCDA752B5 4A2FF39D-13E0-4365-8DEA-7FAD6D6DF405 Category2 659543D6-1A0D-4151-B94C-F44CCDA752B5 599AEA59-8A85-409C-9026-7E4313AF523D Category3 659543D6-1A0D-4151-B94C-F44CCDA752B5 </code></pre> Image's data: <pre><code>Id Name RefId BDD396A2-37A7-4B20-B8C5-8EF2CD58D4C0 Image1 659543D6-1A0D-4151-B94C-F44CCDA752B5 7CDA01FF-B98A-4CDC-A92B-0E31A9CDCD20 Image2 F3FFF612-1D6D-4447-B472-2486C4893CDD </code></pre> Please see this data for the example: Image1 is the image of the product and Image2 is the image of the category. And my query: <pre><code> SELECT Category.Id, Category.Name, Product.Name, Image.Name FROM Category INNER JOIN Product ON Category.ProductId = Product.Id INNER JOIN Image ON Category.Id = Image.RefId -- ON Product.Id = Image.RefId </code></pre> With this query only get Image2 or Image1. My problem is how to get 2 Image with only one query?
Tags
<sql><database><inner-join><multi-query>
Title
How to get data with multiple references to single table
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USLazyCatIT
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow to get data with multiple references to single table
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.