IS NULL usage in mysql-php

By | November 26, 2014

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