Show results of no matches between two tables based on a date

HI,

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.

submitted by /u/mrkoss
[link] [comments]

Posted on