Query with keys and maybe a cursor !

Hi !!

i have 2 tabels
the first one with lots of product
and the next one with a load of descriptions of the products and the only way to receive the descriptions is by comming up with a key combined of 2 post in the products tabel.

this is the query im using when taking out single posts

SELECT description FROM products WHERE
Productid ='something' and producttype ='something' and YearModelIn =< '1191 and ModelOutYear >= '1998';

my question is ! how do i get this one to go thru all records in the database, i wnt all the desciptions for every product slammed to gether to a new tabell ??
i guess i need to create som kind of Cursor and loop thru all the post ?

but how do i do it ??

/JArmo Received on Thu Dec 14 2000 - 08:36:39 CST