ho provato anche così:
SELECT cards.BarCode, cards.NumberCards, clients.ID, clients.Nome, clients.Cognome FROM cards, clients WHERE (NOT cards.NumberCards = '' OR cards.NumberCard IS NOT NULL) AND clients.ID=cards.NumberCard

ma nulla