Joining three tables using MySQL

by

Use ANSI syntax and it will be a lot more clear how you are joining the tables:

SELECT s.name as Student, c.name as Course 
FROM student s
    INNER JOIN bridge b ON s.id = b.sid
    INNER JOIN course c ON b.cid  = c.id 
ORDER BY s.name

More Related Contents:

  1. How to use IN & NOT IN same query [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. Syntax error due to using a reserved word as a table or column name in MySQL
  4. Change MySQL default character set to UTF-8 in my.cnf?
  5. quick selection of a random row from a large table in mysql
  6. nodejs mysql Error: Connection lost The server closed the connection
  7. Best data type to store money values in MySQL
  8. How to fix “Incorrect string value” errors?
  9. MySQL: How to allow remote connection to mysql
  10. Order a MySQL table by two columns
  11. What’s the difference between ” = null” and ” IS NULL”?
  12. add column to mysql table if it does not exist
  13. Querying multiple databases at once
  14. Sorting varchar field numerically in MySQL
  15. SQL: Repeat a result row multiple times, and number the rows
  16. Setting up foreign keys in phpMyAdmin?
  17. How to get an age from a D.O.B field in MySQL?
  18. Invalid default value for ‘dateAdded’
  19. Importing a CSV to MySQL with different date format
  20. MySQL: When is Flush Privileges in MySQL really needed?
  21. MySQL too long varchar truncation/error setting
  22. MySQL: update a field only if condition is met
  23. how to use DISTINCT ON with mysql using ActiveRecord
  24. use a variable for table name in mysql sproc
  25. Split a string and loop through values in MySQL stored procedure
  26. How to create dummy variable columns for thousands of categories in Google BigQuery?
  27. Most efficient way to store IP Address in MySQL [duplicate]
  28. MySQL concurrency, how does it work and do I need to handle it in my application
  29. What is the best way to do incremental backups in MySQL?
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment