Re: [PHP-DB] Nested SQL query problem...

2002-05-29 Thread Antonio Bernabei
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 9:06 AM Subject: [PHP-DB] Nested SQL query problem... > Hi, > > I have a table that contains the prices of software products at different > quantity slab rates. > > I'm trying to get the S

[PHP-DB] Nested SQL query problem...

2002-05-28 Thread Srinivasan Ramakrishnan
Hi, I have a table that contains the prices of software products at different quantity slab rates. I'm trying to get the Slab rate for a given number of licenses for a given product_id. For example, what is the cost of 500 licenses of Product_ID 143 ? The slabs do not continue for an infinite