Bladephp: Now with 8+ codeigniter, php, and laravel project 8+ php project From $37/Month From Rs. 2499/Month

Mysql Left Join Query

by
Category:mysql
php mysql
Mysql Left Join Query

The LEFT JOIN keyword returns all records from the left table (tbl_job), and the matched records from the right table (tbl_job). The result is NULL from the right side, if there is no match. You may also like Left Join Query in Laravel 5 and Left Join Query in Codeigniter.

First you can need database connection in php

Code

$sql = "SELECT wo_jobs.* FROM wo_jobs LEFT JOIN wo_clients ON wo_clients.id = wo_jobs.client_id WHERE wo_jobs.jobcode = '154' "; 
$result = mysqli_query($con,$sql);

0 Comments


Html code work in comment box


Related Post