StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14796649
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-10T10:12:54.753
FavoriteCount
0
LastActivityDate
2013-02-10T10:28:38.470
LastEditDate
2013-02-10T10:28:38.470
LastEditorUserId
722783
OwnerUserId
722783
ParentId
14796639
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Like this: <pre><code>SELECT posts.*,, users.Username FROM posts INNER JOIN users ON posts.ref_id = users.user_id; </code></pre> <hr> <h2>Explanation:</h2> To <code>JOIN</code> to any tables with each others, there are two things; the <code>JOIN</code> type and the join condition. There are three main types of join: <ul> <li><code>INNER JOIN</code>, only the rows that match the join condition will be returned from the two tables no more rows. But:</li> <li><code>LEFT OUTER JOIN</code>, when you join two tables you will have one on the left of the join keyword and the other one will be in the right: FROM Table1 <------------- This is the left table. LEFT OUTER JOIN table2 .... <------------- This is the right table.</li> </ul> In <code>LEFT OUTER JOIN</code> the unmatched rows from the left table will be included in the result set. <ul> <li><code>RIGHT OUTER JOIN</code> the unmatched rows from the right table will be included in the result set.</li> <li><code>CROSS JOIN</code> this will perform a Cartesian product from the two tables.</li> </ul> In our query, the query will reutrn all the users from the <code>users</code> table only if the <code>ref_id</code> equal to the <code>user_id</code> column form the <code>posts</code> table. For more information and explanations: <ul> <li><a href="http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html" rel="nofollow">A Visual Explanation of SQL Joins</a>.</li> <li><a href="http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins" rel="nofollow">Another Visual Representation of SQL Joins</a>.</li> <li><a href="http://dev.mysql.com/doc/refman/5.0/en/join.html" rel="nofollow">Join syntax in MySQL</a></li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POmysql join select explained
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMahmoud Gamal
UserOwnerUserId
1. USMahmoud Gamal
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 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.