Can anybody help with this query? It should be like this -

SELECT * FROM book WHERE supplierID=2 AND quantityInStock>0 ,

but the record should also be included in the result set if the table has a record with the same isbn and supplierID=9. How do I go about this?

(Note to self: next time when designing a database from scratch, think really good, so that you won't have to build lame queries 4 years later.)