Trouble with JOINS

Hi!

I have some stupid problem wich is driving me nuts.

This is my 2 tables.

CREATE TABLE one ( one_id varchar(23)
day varchar(10),
view int4,
two_id varchar(32),
PRIMARY KEY (one_id)
);

CREATE TABLE two ( tow_id varchar(32),
user varchar(12) NOT NULL,
PRIMARY KEY (client_id)
);

table one is tracking views of some user, and table two is actual data
of that user.

What i want to get from SQL is something like this

user view
u1 34
u2 14
u3 8

The data in tabel are like this
two_id day view one_id
aaa 1 15 1
bbb 1 7 2
ccc 2 2 3
bbb 2 7 4
aaa 3 19 5
ccc 3 6 6

two_id user
aaa u1
bbb u2
ccc u3

I hope you'll understand what i want to do. If not tell me.

--
Thanks,
Uros