qyery using keys ??
Date: Thu, 14 Dec 2000 15:34:15 +0100
Message-ID: <Pine.SOL.4.10.10012141459320.13806-100000_at_kairos.algonet.se>
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 ??
/JarmoSELECT 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 ??
/JarmoSELECT 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 - 15:34:15 CET