What am I doing wrong?

I think I'm doing something fundamenatally wrong when attempting
to use multiple tables. Can someone point out what I'm missing
from the following snippet:-

------------------------------------------
CREATE TABLE players
(player_id INTEGER NOT NULL Primary key,
player VARCHAR,
club_id INTEGER);

CREATE TABLE clubs
( club_id INTEGER NOT NULL Primary key,
club VARCHAR ,
foreign key (club_id) references players);

insert into players values (1, 'Rivaldo');
insert into players values (2, 'Kleivert');
insert into players values (3, 'Zidane');
insert into players values (4, 'Davids');

insert into clubs values (1, 'Barca');
insert into clubs values (2, 'Juve');

select player,club from players,clubs;
------------------------------------------

This is the output I get:-

player | club
----------+-------
Rivaldo | Barca
Kleivert | Barca
Zidane | Barca
Davids | Barca
Rivaldo | Juve
Kleivert | Juve
Zidane | Juve
Davids | Juve
(8 rows)

This is the output I would like:-

player | club
----------+-------
Rivaldo | Barca
Kleivert | Barca
Zidane | Juve
Davids | Juve
(4 rows)

It's probably obvious to everyone, but I don't see what I've done
wrong. Any enlightenment would be much appreiated.

--
John