![Mysql Mysql](/uploads/1/2/5/6/125630190/844724068.png)
Not Equal in Inner Join not working – Learn more on the SQLServerCentral forums. SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL.
![Not Not](/uploads/1/2/5/6/125630190/576147798.gif)
Supplieridsuppliernamecitystate100MicrosoftRedmondWashington200GoogleMountain ViewCalifornia300OracleRedwood CityCalifornia400Kimberly-ClarkIrvingTexas500Tyson FoodsSpringdaleArkansas600SC JohnsonRacineWisconsin700Dole Food CompanyWestlake VillageCalifornia800Flowers FoodsThomasvilleGeorgia900Electronic ArtsRedwood CityCaliforniaLet's look for all records in the suppliers table where the suppliername does not contain the letter 'o'. Enter the following SQL statement: SELECT.FROM suppliersWHERE suppliername NOT LIKE '%o%';There will be 1 record selected. These are the results that you should see.