Write a mysql statement to find the name, birth, department name, department block from the given tables

Solution

MySQL Join is used to retrieve data from self or more tables from a single statement based on the values of common column between tables.

The following statement retrieves data from both students and departments tables.

mysql> SELECT name, birth, dept_name, dept_block
    -> FROM students
    -> JOIN departments using(dept_id);

Output of the above statement -

+--------------+------------+--------------------------+------------+
| name         | birth      | dept_name                | dept_block |
+--------------+------------+--------------------------+------------+
| Maria Gloria | 1994-03-12 | Information Technology   | C-Block    |
| John Smith   | 1993-02-07 | Computer Science         | B-Block    |
| Gal Rao      | 1992-09-11 | Electronic Communication | D-Block    |
| Jakey Smith  | 1990-08-31 | Information Technology   | C-Block    |
| Rama Saho    | 1994-12-09 | Computer Science         | B-Block    |
| Maria Gaga   | 1993-10-09 | Electronic Communication | D-Block    |
+--------------+------------+--------------------------+------------+