Databases
StackOverflow2013
Postsdbo
POHow to restrict FROM in SQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to restrict FROM in SQL
    primarykey
    data
    text
    <p>Sorry if the question's title doesn't mean anything, I'm still a beginner and I just don't know how to explain it.</p> <p>Here's my current SQL query that works fine</p> <pre><code>select teams.id as team_id, teams.team_name, players.type_name, sum(points) as points from teams inner join gameweeks on teams.id = gameweeks.team_id inner join gameweeks_players on gameweeks.id = gameweeks_players.gameweek_id inner join players on gameweeks_players.player_id = players.id inner join player_fixtures on players.id = player_fixtures.player_id AND player_fixtures.gw_number = gameweeks.number group by teams.id, players.type_name </code></pre> <p>In rails, I translated this query into </p> <pre><code>Team.joins(gameweeks: :players). joins("inner join player_fixtures on players.id = player_fixtures.player_id AND player_fixtures.gw_number = gameweeks.number"). group("teams.id, players.type_name"). select("teams.id, teams.team_name, players.type_name as type, sum(points) as points") </code></pre> <p>In rails, I have these 2 models.</p> <pre><code>class League &lt; ActiveRecord::Base belongs_to :user has_many :league_teams has_many :teams, :through =&gt; :league_teams end class Team &lt; ActiveRecord::Base has_many :gameweeks has_many :league_teams has_many :leagues, :through =&gt; :league_teams end </code></pre> <p>I would like to modify my query to only the teams that are associated with a league (I'd like to pass the ID of that league somehow)</p> <p>I just don't know how to do that and I'm missing the knowledge to google it with the right keywords...</p> <p>Could you point me in the right direction please?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USSyl
    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
    1. This table or related slice is empty.
    1. COhttp://www.sql-tutorial.com/sql-where-sql-tutorial/
      singulars
      1. POHow to restrict FROM in SQL
      1. USRobert Harvey
    2. COpretty sure what you're looking for is just `league.teams.joins(gameweeks: :players). joins("inner join player_fixtures on players.id = player_fixtures.player_id AND player_fixtures.gw_number = gameweeks.number"). group("teams.id, players.type_name"). select("teams.id, teams.team_name, players.type_name as type, sum(points) as points")`
      singulars
      1. POHow to restrict FROM in SQL
      1. USgregates
    3. CO@RobertHarvey that doesn't help me at all. At no point the page talks about doing a where through a joint_table for example
      singulars
      1. POHow to restrict FROM in SQL
      1. USSyl
 

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