Find not equal to in MySQL in two table with while loop

Description

Selecting Data from Your MySQL two Tables Using Not equal to with while loop Retrieving Records from Multiple Tables MySQL SQL Syntax Not equal to select where id not in another table MYsql with while loop

php mysql select from multiple tables mysql select where id not in another table sql select from multiple tables without join how to retrieve data from multiple tables in sql

SELECT * FROM addstudent WHERE adminno NOT IN ( SELECT adminno FROM photoimg )