Hi,
Is it possible to obtain certain records from a query without creating a
query for each item?
i.e.
SELECT quoteprod_id, prod_id, descrip, cost AS info1,
(SELECT quoteprod_id, prod_id, descrip, cost FROM products WHERE
quoteprod_id = 1435) AS info2
(SELECT quoteprod_id, prod_id, descrip, cost FROM products WHERE
quoteprod_id = 1240 ) AS info3
FROM products
WHERE quoteprod_id = 1120
instead of creating a record for each such as:
SELECT quoteprod_id, prod_id, descrip, cost AS info1,
FROM products
WHERE quoteprod_id = 1120
SELECT quoteprod_id, prod_id, descrip, cost AS info1,
FROM products
WHERE quoteprod_id = 1435
SELECT quoteprod_id, prod_id, descrip, cost AS info1,
FROM products
WHERE quoteprod_id = 1240
Thanks!
Sanj