How do I combine two tables together and echo records from these two tables? - Php

See more:

SQL

PHP

Hi, new coder here.
I have two tables. One is the employee table that holds all records about all the employees and the other is performance table which holds records about the performance of each employee.

What I wanted to achieve is to display two tables with the first one being the performance review of the logged in employee and the other one being the performance review of the other employee. (Logged in employee is the manager and every employee has their managerID set to the employeeID of the manager. employeeID is the primary key on employee table.)

So far I have managed to output the records of the manager and my code is set up as follows:

<?php
$sql = "select reviewID, employeeID, status, reviewYear, dateCompleted from review where employee_id = '$_SESSION[who]'"; //note that employeeID exists on review table but the primary key of review table is reviewID
?>
$results = $dbConn->query($sql)
or die ('Problem with query: ' . $dbConn->error);

I can then fetch these records and echo them in a table without problem.

The thing that I am trying to figure out is creating another table where the record comes from two different table. For the table that I wanted to create, I want to get all records of other employees from review table, their surname from employee table where managerID (from employee table) = '$_SESSION[who]' (which in this case, the logged in user is the manager).

I hope that you would be able to help me with this.

What I have tried:

I have tried doing multiple sql queries using if statements and creating the second table but failed to do.