Rewrite the SQL statement you just created to use a single SELECT statement.


SELECT prod_id, quantity FROM OrderItems
WHERE quantity = 100 OR prod_id LIKE 'BNBG%'
ORDER BY prod_id;

Comment on this FAQ