MySQL query to return rows which are not listed in another table

nkolreshima1

New Member
I have two tables in MySQL DB PHPMyAdmin:\[code\]Table-1: T1\[/code\]
Jjx4d.png
\[code\]Table-2: T2\[/code\]
lkFYX.png
I need to write a mysql query which will return all IMEIs from \[code\]T1\[/code\] which are not listed in \[code\]T2\[/code\].For example, in this case query should return \[code\]123456781235176\[/code\].Thanks.
 
Top