How to fetch the data from multiple tables

[harshmail24]

I have four tables in mysql phpmyadmin
Tables are employee, project, project_progress,client
employee:
emp_id
name
email_id
password
project:
project_id
project_name
client_id
client:
client_id
client_name
email_id
password
project_progress:
id
client_id
project_id
emp_id
project_progress
how a admin check the details if select the name of anyone . please how to manage these tables