Hi, I need a small SQL statement written. I know it's pretty simple via sub query or something, but I can't get my head around it.
The general idea is that I will mail people who have not been mailed before, or it has been over 30 days. The comms routine already has it's own resending process, hence, we care about is_complete.
You will not have access to my database. I have two tables:
rgid = int
rgid = int
updated (UTC integer)
1. You can have more than one comms per ghost.
2. There may not be any comms for a ghost.
I need to return a distinct list of ghosts (the whole row, not just the rgid) where:
1. no comms exists at all yet OR
2. comms exist, but all of them are is_complete=1 and the most recent comms is updated over 30 days ago.
77 los freelancers están ofertando un promedio de £113 para este trabajo.
Hello, sir. My ranking is TOP 5TH in freelancer.com as you can see my profile: (https://www.freelancer.com/u/kchg.html). I'd like to discuss with you in detail. Kind Regards
Hi! I have 10+ years of web developing experience, I can promise quality and responsibility. We can start immediately. The price would be less if i have access or tables with some demo data.
Hi, I am joomla, virtuemart expert having 5 years of experience. Recently i completed these projects http://www.ticotogo.com http://pandanusmooloolaba.com.au http://www.mscertkit.nl Please award me the project.