You haven't told how many members are there.
Anyway... i've worked out something with a colleague at work...
Given your tables:
*CREATE TABLE `list_problem_members` ( `id` int(11) NOT NULL
auto_increment, `member` varchar(11) NOT NULL default '', PRIMARY KEY
(`id`) );*
**
*CREATE TABLE `list_prob
Brian,
>Let's say a member completes action 'abc'. We want to query the
>member_actions table for all members that have also completed action 'abc'.
>We then want to determine what the top 3 other actions are that were
>completed by members who have completed action 'abc', while making sure tha
On Tue, 28 Mar 2006, Brian Erickson wrote:
> To: mysql@lists.mysql.com
> From: Brian Erickson <[EMAIL PROTECTED]>
> Subject: Customer Recommendation Query
snip
> We are using MySQL version 3.23. There are approximately
> 500 unique rows in the 'actions' tab
We are looking for some help with queries that will accomplish a similar
feature to what Amazon does. When you purchase a product, Amazon looks at
all other people who have purchased that product, and then looks at all of
the OTHER products those people have purchased, and uses that data to
suggest