var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: People Who bought X also bought Y,Z,R,D
I need your help...
I'm trying to build an application that will tell me what items usually sell along with an item we will call "X".
I have a huge list of tickets with the following cells: ticket number, item code, amount of items sold, and date (which won't be needed)
What I need is that when I select item 203923 e.g., the query will give me a list of 10 other items (in order of sales) which usually sell along with the first one.
I would really appreciate anyone's help.
first create query that will select only ticket numbers that have X item code, you only need ticket number field, save it.....
create another query with your table and the new query with selected ticket numbers.....
link those two by ticket number field using relation one-to-one....
there's more to it than that, eh
select top 10
where itemcode <> 203923
and ticketno in
( select ticketno
where itemcode = 203923 )
by sum(amtsold) desc
Last edited by r937; 08-18-03 at 11:55.
I forgot about those top 10, it changes totally....