Databases
StackOverflow2013
Postsdbo
POPerforming joins
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPerforming joins
    primarykey
    data
    text
    <p>So this my first run into mysql databases, </p> <p>I got a lot of help from my first question : <a href="https://stackoverflow.com/questions/14774071/mysql-first-database-structure-help-please">MYSQL - First Database Structure help Please</a></p> <p>and built my database as pitchinnate recommended</p> <p>I have :</p> <p>Table structure for table club</p> <pre><code>Column Type Null Default id int(11) No clubname varchar(100) No address longtext No phone varchar(12) No website varchar(255) No email varchar(100) No </code></pre> <p>Table structure for table club_county</p> <pre><code>Column Type Null Default club_id int(11) No county_id int(11) No </code></pre> <p>Table structure for table county</p> <pre><code>Column Type Null Default id int(11) No state_id tinyint(4) No name varchar(50) No </code></pre> <p>Table structure for table states</p> <pre><code>Column Type Null Default id tinyint(4) No longstate varchar(20) No shortstate char(2) No </code></pre> <p>I set up foreign key relationships for everything above that looks that way.... states.id -> county.state_id for example</p> <p>What I tried to run :</p> <pre><code>SELECT * FROM club JOIN states JOIN county ON county.state_id=states.id JOIN club_county ON club_county.club_id=club.id club_county.county_id=county.id </code></pre> <p>This didn't work... I'm sure the reason is obvious to those of you who know what SHOULD be done.</p> <p>What I'm trying to do is </p> <p>get a listing of all clubs, with their associated state and county(ies)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJohn MacKenzie
    plurals
    1. PL
      singulars
      1. LTLinked
    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. POPerforming joins
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO@dukeling, thanks for making it more readable, what tags should I be using ?
      singulars
      1. POPerforming joins
      1. USJohn MacKenzie
    2. COFor this particular question I wouldn't use tags other than `mysql`, since the question requires pretty standard MySQL knowledge and any other tags are too broad and people who follow these tags don't necessarily know anything about MySQL (though it's a pretty standard SQL `join` query, so that one's not bad). When editing a question, I generally just leave tags that are vaguely related to the question since some people may differ in opinion. I generally just add tags where needed.
      singulars
      1. POPerforming joins
      1. USDukeling
    3. COgotcha, how did you edit the readability ?
      singulars
      1. POPerforming joins
      1. USJohn MacKenzie
 

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