HI
I have a products table, which has a foreign key reference from a markets table.

Markets table is like this
1. Market (PK) the market column is the primary key
2. Description

and a product table with a one to many relationship
1. Product (PK) primary key
2. Market(Fk) foreign key
3. Product description

Now i want to extract DISTINCT from the products table, and all values from the products table, or summary values. e.g 3 of the products.

markets category

electronics sonyJ70
electronics toshiba3000
computers dell navasion
computers compaq30000
computers Compaq500
books At the speed of light -Bill gates
etc


I have a repeated region on my site. That repeats the products table. But what i get is this a repeat of both the products and markets. I only want DISTINCT markets repeated and all products repeated, or summary of 3 products. As below


e.g.

ELECTRONICS
sonyj70, toshiba3000 etc

COMPUTERS
dell navasion, compaq3000, compaq500

BOOKS
at the speed of light

how do i loop through this collection to format it the way i want, e.g. present it to be in the format as in http://shopping.yahoo.com

thanks
afrika