sql select statement

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

... etc


rgid = int

is_complete (0/1)

updated (UTC integer)

... etc


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.

Habilidades: MySQL, SQL

Ver más: programmer fixed pay, fixed pay job usa, additional fixed pay, php coder pay happy, wcf application insert database sql 2008 vbnet query, sub account query, sql database size query, oracle sql format currency query, sql server 2008 query latitude longitude radius, oracle sql order date query example, sql microsoft project query, oracle sql statement select employees database work projects, sql add decimal query oracle, sql parentchild tree query, sql server remote query mysql, sql menu tree query, sql tree menu query, sql parent child query xml, sql parent child query, converting access 2000 sql, microsoft sql express csv import, configura microsoft sql per primavera, sample excel sqlrequest access db2 sql, converting access database sql server 2008, conversion access 2000 sql server 2005

Información del empleador:
( 5 comentarios ) Ruislip, United Kingdom

Nº del proyecto: #12744810

72 freelancers están ofertando el promedio de £110 para este trabajo


Hello, sir. My ranking is TOP 5TH in as you can see my profile: ( I'd like to discuss with you in detail. Kind Regards

£750 GBP en 3 días
(188 comentarios)
£30 GBP en 1 día
(135 comentarios)
£20 GBP en 1 día
(61 comentarios)

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.

£100 GBP en 1 día
(38 comentarios)
£23 GBP en 1 día
(150 comentarios)
£10 GBP en 1 día
(105 comentarios)

Hi. I am a skillful and talented Web developer. I have more than 8 years experience with Web site development, so no problem for MySQL/SQL. - Frontend [login to view URL] [login to view URL] http:// Más

£555 GBP en 10 días
(3 comentarios)

Hello sir.... I am interested. Please share more details.

£18 GBP en 1 día
(88 comentarios)

Hi, I am joomla, virtuemart expert having 5 years of experience. Recently i completed these projects [login to view URL] [login to view URL] [login to view URL] Please award me the project.

£23 GBP en 1 día
(118 comentarios)

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

£23 GBP en 1 día
(6 comentarios)

Greetings! Please consider my bid. I can help you with mysql select. Let's chat right now. Best regards, -Alexandre Kharlamov

£20 GBP en 1 día
(32 comentarios)
£260 GBP en 10 días
(14 comentarios)

Hello! Hopefully you are fine! Please tell me what is your statement requirement and I would do it for you! Regards Mushrraf Baig Ashraf

£18 GBP en 1 día
(49 comentarios)

Hi there, my name is Brendan and i am an expert in Web Development holding over 7 years experience in the field.I specialise in building high quality websites, website scripts, responsive templates and building sites w Más

£13 GBP en 0 días
(20 comentarios)
£23 GBP en 0 días
(14 comentarios)

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including SQL. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who hav Más

£250 GBP en 2 días
(10 comentarios)

Hello, Greetings ! I am writing you regarding the job description and you would be happy to know that I hold all the skills which are required to complete the project as I have 6+ years of experience on core Php, Más

£23 GBP en 1 día
(6 comentarios)

-- 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=[login to view URL]) union select [login to view URL], [login to view URL], "old comments" as state from Más

£18 GBP en 0 días
(26 comentarios)

Hi, Hope you doing good? I am experienced PHP developer having expertise in e-commerce domain using Zen Cart, Wordpress, Codeigniter, OsCommerce, CreLoaded, MVC framework, Prestashop, Opencart, HTML5, Bootstrap, Más

£13 GBP en 0 días
(12 comentarios)

Dear Hiring Manager, Education: Masters Degree Experience: 4+ years Will be done for 30$ and quick turnaround, I will do it for you with perfection and I will keep working on it until you are 110% satisfied w Más

£250 GBP en 3 días
(21 comentarios)