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.
72 freelancers están ofertando el promedio de £110 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 [url removed, login to view] [url removed, login to view] [url removed, login to view] Please award me the project.
Hi Let me know how can i help you. I know how to do it. Please specify key field etc and what is the object that you want to achieve from this script. Please revert Thanks Vijay
-- Hi! I think it will be like this: select g.*, "no comments" as state from ghosts g where not exists (select * from comms c where g.rgid=[url removed, login to view]) union select [url removed, login to view], [url removed, login to view], "old comments" as state from Más