R roadrage Registered User. Local time Today, 16:17 Joined Dec 10, 2007 Messages 62 Mar 10, 2008 #1 I have a Database that contains a number Albums and Artists. I also have a table that contains orders from customers for these albms. Basically i want to track which album and artist is bought most? Can any one help?
I have a Database that contains a number Albums and Artists. I also have a table that contains orders from customers for these albms. Basically i want to track which album and artist is bought most? Can any one help?
R roadrage Registered User. Local time Today, 16:17 Joined Dec 10, 2007 Messages 62 Mar 10, 2008 #2 Its ok please ignore as i have solved this by doing a group by count.!