Help with a select statement

[Tonata]

Hi all,

I have a table called orders, with columns quantity, price, priceRange, etc, etc... and I have another table called price range with 3 columns, ID, priceFrom, priceTo...

The value of priceRange in orders is the ID in priceRange table so that's how the two tables are linked.. I want to select/retrieve the price of an order from orders provided that it is NOT NULL, and List the values by creating a dynamic html table.. BUT if price NULL then I must substitute it with priceRange from priceRange table... Can anyone please help me with the SELECT statement that will archive this.

[sneakyimp]

Not sure what you mean by archive. This select may be useful.

SELECT o., pr. FROM orders o LEFT JOIN price_range pr ON pr.ID=o.priceRange

Then you could loop through the results checking for empty values using PHP functions [man]empty[/man] or [man]is_null[/man].