Join with a condition between two values
I have two tables [sales] and [payments] and I want to see if a payment is made between the sale’s product start date and the end date of the sale BUT sometimes the product hasn’t started yet!
I have two tables [sales] and [payments] and I want to see if a payment is made between the sale’s product start date and the end date of the sale BUT sometimes the product hasn’t started yet!