SELECT B.* FROM BOOK B  WHERE B.AID IN (SELECT AID FROM BOOK WHERE TITLE LIKE '%?%');

SELECT B1.* FROM BOOK B1  , BOOK B2 WHERE B1.AID = B2.AID AND B2.TITLE LIKE '%?%';

SELECT B1.* FROM BOOK B1 LEFT OUTER JOIN  BOOK B2 ON B1.AID = B2.AID WHERE B2.TITLE LIKE '%?%';