Good Day Experts!
I am not sure if I can do all the required "checks" in one query. Hopefully you can help me find out if it is possible and how to do it.
Select * from Status with the following requirements:
- Status.ServiceFailure = 1
- Status.SFRejected = 1
- (DW1NonPay InvoiceNumber/TrackingNumber from Status not found
(DW1NonPay InvoiceNumber/TrackingNumber from Status found but
DW1NonPay.DateImported > Status.DatePC)
Please ask questions and let me know your opinions.