MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE LIKES(DRINKER VARCHAR(50), DRINK VARCHAR(50),ODATE DATE)
INSERT INTO LIKES VALUES('Joe','Vodka',null),('Jack','Beer',null),('Janet','Vodka',null)
CREATE TABLE ORDERS(DRINKER VARCHAR(50), DRINK VARCHAR(50),ODATE DATE)
INSERT INTO ORDERS VALUES('Jack','Beer',null),('Janet','Whisky',null)
SELECT DRINKER, DRINK
FROM LIKES
WHERE DRINKER NOT IN 
    (SELECT DRINKER
     FROM ORDERS 
     WHERE ODATE IS NULL)
     AND DRINK NOT IN
         (SELECT DRINK 
          FROM ORDERS 
          WHERE ODATE IS NULL)
 ORDER BY DRINKER , DRINK ASC;
 


DRINKER
DRINK


Joe
Vodka


SELECT l.DRINKER, l.DRINK
  FROM LIKES l
 WHERE NOT EXISTS 
      ( SELECT 0
          FROM ORDERS 
         WHERE ODATE IS NULL
           AND ( DRINKER = l.DRINKER
              OR DRINK = l.DRINK ) )
 ORDER BY l.DRINKER , l.DRINK;
 


DRINKER
DRINK


Joe
Vodka