hello
i Have 2 tables in my SQL server database.

1. Markets e.g computer, electronics toys etc
2. Products e.g. laptops, nokia, ssl certs etc

Now i would like to create a market like ebay, MSN yahoo shopping e.g. http://shopping.yahoo.com

In my products table, i have a;
1. products which is the Primary key
2. and market which is the Foreign key

* the market table just has the market type which is the primary key and description. this primary key is the foreign key reference in the products table.

I would want to retrieve data based on market types e.g.

COMPUTING AND THE INTERNET
laptops, desktops, web hosting etc

ELECTRONICS
Digital Cameras, TVs, Cell Phones, More...

VIDEO GAMES

PS2, Xbox, Game Boy Advance, Consoles, More...

how do i write a query to do this or the necessary script? see examples at
http://shopping.yahoo.com or http://shopping.msn.com

thank you
1newday

:):D

What platform do you use for developing the site? (asp.net, php, asp, jsp)
You're trying to build this functionality into a site, don't you? (it could be a windows app)