You can use multiple tables in your single SQL query. The act of joining in MySQL refers to smashing two or more tables into a single table.
Assume we have two or more tables in TUTORIALS. Now take a look at the examples given below.
$sql = "SELECT wo_jobs.* FROM wo_jobs INNER JOIN wo_clients ON wo_clients.id = wo_jobs.client_id INNER JOIN wo_sectors ON wo_sectors.id = wo_jobs.sector_id WHERE wo_jobs.jobcode = '154' "; $result = mysqli_query($con,$sql);