SELECT a.fruits FROM tableA a where a.fruit NOT IN (SELECT b.fruit2 from tableB b where b.fruit1 = 'apple') AND a.fruits != 'apple';

This will work provided that 'apples' appear only in the fruit1 column of tableB.

Don't expect this query to work out of the box. I won't give you the ready query, thats something that against the rules of this forum. This is just a form of it to show you on what lines you should be thinking over it.