Hello Everyone
I have a question about transfer money from by Customers
I have a table for transferring money ( InvoiceID , Customer_name , Date , amount and Note )
I would like to make query for transferring money , When 1 Customer don't transfer money more than 10 days , it tells me , this customer didn't transfer money 10 days or more .
and also I don't want His name appear less than 10 days , but when He transfers many times , His name don't repeat only last transfer + 10 days .
I used this Query , but When pass more than 10 days His name don't appear , I want to appear His name is more than 10 days .