Re: Amazon alike collaborative filtering
Yes
here
select t2.product_id , t1.name from t2
join t2 as related_users
on
t2.product_id != related_users.product_id
and
t2.user=related_users.user
join t1
on
t1.id=t2.product_id
where related_users.product_id = 2
Diego Medina
Web Developer
http://www.fmpwizard.com
P.S. Please read
this post if you are going to post code
Subject
Written By
Posted
November 09, 2007 08:48PM
November 09, 2007 10:22PM
November 10, 2007 02:07AM
Re: Amazon alike collaborative filtering
November 10, 2007 02:50PM
December 25, 2007 09:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.