SQL question

[Florian Bogeschdorfer]

Hi all!

Say I have two tables:

TABLE CUSTOMER with fields ID,NAME,ADRESS

And

TABLE PAYBACKCARD with fields CUSTOMER_ID,ID,CARDNUMBER

If I search for customers with cards, I do "SELECT * FROM
CUSTOMER,PAYBACKCARD WHERE CUSTOMER.ID=PAYBACKCARD.CUSTOMER_ID"

Fine. But now I want to find all customers WITHOUT card. How can I do this?
In this case there is no link between the two tables, I need "SELECT * FROM
CUSTOMER WHERE there is no link between the tables..."

TIA

Florian