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