Mysql Query Inner Join
SELECT E.Name
FROM Eatables E INNER JOIN
Confirm_Eatables CE ON CE.Eatbles_Id != E.Sno

SELECT E.Name
FROM Eatables E INNER JOIN
Confirm_Eatables CE ON CE.Eatbles_Id != E.Sno

SELECT E.Name
FROM Eatables E INNER JOIN
Confirm_Eatables CE ON CE.Eatbles_Id != E.Sno

SELECT E.Name
FROM Eatables E INNER JOIN
      Confirm_Eatables CE ON E.Sno != CE.Eatbles_Id
GROUP BY E.Name

SELECT a.Name
FROM tblEatables a
LEFT JOIN tblConfirm_Eatables b ON a.Sno = b.Eatables_Id
WHERE b.Eatables_Id IS NULL

SELECT a.Name
FROM tblEatables a
LEFT JOIN tblConfirm_Eatables b ON a.Sno = b.Eatables_Id
WHERE b.Eatables_Id IS NULL

SELECT E.Name FROM Eatables
                EXCEPT ALL
  SELECT E.Name FROM Eatables E INNER JOIN
         Confirm_Eatables CE ON CE.Eatbles_Id = E.Sno