Search results

I'd like to create a query where when a book is ordered, the book quantity in a different table is updated and subtracts the quantity ordered. I'd also like another query where, when a books quantity falls below 5, the book title, with the reorder level is sent to either a new table called...