Hey ya'll, I'm having a bit of difficulty figuring out how to run this
query in a way that users won't have gray hair by the time it actually
finishes. Here's my setup:
(Very) basically, I'm setting up a gear rental system, so I'm keeping
track of (a) all of my gear in one table ("gear") and (b) the gear
reservations in a second table ("reservations"). Both have a "gearid"
field. "reservations" also has two date fields, "checkoutdate" and
"returndate". Okay, now here's what I'm trying to do: given a certain
time period, how can I find all gear that ...