I have two tables, drivers and trips. I want to show which drivers are not used on a specific day on trips (based on a text box field on a form). I have a trip date field on trips to use for the comparison.
I don’t think i can do this with an unmatched query, and having trouble finding SQL i can use for this.
Any help is appreciated.