how about something like this, which finds one row (if any) with the
lowest in-stock price, UNIONs it with the highest out-of-stock price (if
any), and then returns just one row, including whether that was an
in-stock or out-of-stock price:
(SELECT col1, price, quantityOnHand, 1 as inStock
FR
Hey list;
I have a case where I need to fetch a product row from a table
containing price information about some products, and where every
product can have multiple rows but from different suppliers (thus with
different prices and stock information).
However, I'm trying to create a query which f