SELECT c.no_carte, nom_tit, date_carte
FROM carte c, achat a
WHERE date_carte < "2011-11-03"
AND c.no_carte = a.no_carte
AND c.no_carte NOT IN
    (
    SELECT c.no_carte
    FROM carte c, achat a
    WHERE date_achat <> date_carte
        AND c.no_carte = a.no_carte
    )