Tag Archives: fetching records with null values using a join query

IS NULL usage in mysql-php

Example: we have two tables tbl_students,tbl_marks using a join query to fetch the students not having records in marks table.It should work using a single query see the blow example without using subquery. For creating students and marks table use the below query

use the below query to display null records