What kind of join do I need?

by

You would use an INNER join to establish the relationship between the common gameid field;

select
  votes.userid,
  games.title
from games
  inner join votes on (votes.gameid = game.gameid)
where
  votes.userid = 'a'

More Related Contents:

  1. What is semi-join in database?
  2. Decrease salary using a SQL query
  3. I need help formatting inner join command in SQL query
  4. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  5. Sort by column ASC, but NULL values first?
  6. Search All Fields In All Tables For A Specific Value (Oracle)
  7. Using an Alias column in the where clause in Postgresql
  8. How to get next/previous record in MySQL?
  9. SQL best practice to deal with default sort order
  10. ORA-12560: TNS:protocol adaptor error
  11. How to Create a real one-to-one relationship in SQL Server
  12. Select statement to find duplicates on certain fields
  13. How to use DISTINCT and ORDER BY in same SELECT statement?
  14. Getting only Month and Year from SQL DATE
  15. How does GROUP BY work?
  16. Linq version of SQL “IN” statement
  17. What is a self join for? (in english)
  18. Check for file exists or not in sql server?
  19. How to ORDER BY a SUM() in MySQL?
  20. How to create a PivotTable in Transact/SQL?
  21. Alternate of lead lag function in SQL Server 2008
  22. SQL – Select first 10 rows only?
  23. SQL – Inserting a row and returning primary key
  24. How do I start auto increment from a specific point?
  25. How to search SQL column containing JSON array
  26. How to use a dynamic parameter in a IN clause of a JPA named query?
  27. Perform regex (replace) in an SQL query
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. Determine if one coordinate is in radius of another
  30. Entity Framework Skip/Take is very slow when number to skip is big

Leave a Comment