Databases
StackOverflow2013
Postsdbo
POSQL SELECT query for multiple tables
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL SELECT query for multiple tables
    primarykey
    data
    text
    <p>I have these tables:</p> <pre><code>USERS: user_ID username password email data_registered POSTS: post_ID user_ID post_title post_content post_data CATEGORY: cat_ID post_ID cat_title </code></pre> <p>Now I used this situation:</p> <p>in USERS table I have: </p> <pre><code>(1, 'admin, '5hj63jhn120011', 'admin@gmail.com', '15.02.2012') </code></pre> <p>in POSTS table: </p> <pre><code>(1, 1, 'Hello', 'Content goes here', '15.02.2012') </code></pre> <p>in CATEGORY table: </p> <pre><code>(1, 1, 'web developing'), (2, 1, 'software programming'), (3, 1, 'web design') </code></pre> <p>So I have only 1 user, 1 post, and 3 categories. How to select them in one statement? I used this statement: </p> <pre><code>SELECT p.post_title, p.post_content, u.username, c.cat_title FROM posts p LEFT JOIN users u ON p.user_ID = u.user_ID LEFT JOIN category c ON c.post_ID = p.post_ID </code></pre> <p>but this select 3 rows with 3 different categories. I'm still learning to make this JOIN queries properly so I would appreciate any help.</p> <p>And after that, for example, I will have situation to select data from COMMENTS table as well, so this is going to be complicated. Just to mention this is comment table:</p> <pre><code>COMMENTS: comment_ID user_ID post_ID c_username c_email c_content </code></pre> <p>It's gonna be tough to select this comments with user , post and category altogether. So one more question would be can I split this select queries and is this a good practice generaly (when developing with PHP) ? </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USArion
    1. USBojan Savic
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL SELECT query for multiple tables
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COcan you provide the sample result set you need?
      singulars
      1. POSQL SELECT query for multiple tables
      1. USVikram
    2. COIt has nothing to do with your question bu are you sure that there should be only one post corresponding to a category?
      singulars
      1. POSQL SELECT query for multiple tables
      1. USC.Champagne
    3. CO@C.Champagne you mean one post - one category?
      singulars
      1. POSQL SELECT query for multiple tables
      1. USBojan Savic
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload