Sql

Search

mysql inner join 3 tables

SELECT student.firstname,
       student.lastname,
       exam.name,
       exam.date,
       grade.grade
  FROM grade
 INNER JOIN student ON student.studentId = grade.fk_studentId
 INNER JOIN exam ON exam.examId = grade.fk_examId
 ORDER BY exam.date

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to add where command in update comand with joins
Sql :: date diff sql
Sql :: sql update table remove spaces
Sql :: rename constraint postgresql
Sql :: drop index oracle
Sql :: install postgresql centos 5
Sql :: sql unique rows
Sql :: mysql CAST(amount as float)
Sql :: show slave status mysql
Sql :: psql select unique
Sql :: oracle sql date get month
Sql :: mysqli last row
Sql :: postgresql dump and restore db
Sql :: sql in array query
Sql :: sql select second max
Sql :: postgres delete all tables
Sql :: find lowest number in sql
Sql :: database disk image is malformed sqlite fix ubuntu
Sql :: mysql update with subquery
Sql :: how to drop a table in mysql
Sql :: nested if in mysql
Sql :: drop multiple columns in sql
Sql :: sql query to get the number of rows in a table
Sql :: vowels in sql
Sql :: write pandas dataframe to postgresql table psycopg2
Sql :: postgres : ERROR: division by zero
Sql :: mysql delete duplicate rows but keep one
Sql :: sqlalchemy return id after insert
Sql :: get column types SQL SERVER
Sql :: how to query date in sql server

Search

SQL

mysql inner join 3 tables

ADD CONTENT