Subquery not working 1

[duncdude]

Hi

Can anyone please help me with this... i can't seem to get it to work!?

SELECT parexel_staff.name, parexel_skills.skill, parexel_activity.date
               FROM   parexel_staff, parexel_skills, parexel_activity
               WHERE  parexel_staff.name = parexel_activity.name
               AND    parexel_activity.skill = parexel_skills.skill
               AND    parexel_skills.skill = 'CGI'
               AND    CURRENT_DATE [red]>[/red] (parexel_activity.date + INTERVAL parexel_skills.retake MONTH)
               AND    parexel_staff.name [blue]NOT IN[/blue]
               (
               SELECT parexel_staff.name
               FROM   parexel_staff, parexel_skills, parexel_activity
               WHERE  parexel_staff.name = parexel_activity.name
               AND    parexel_activity.skill = parexel_skills.skill
               AND    parexel_skills.skill = 'CGI'
               AND    CURRENT_DATE [red]<[/red] (parexel_activity.date + INTERVAL parexel_skills.retake MONTH)
               );

Kind Regards
Duncan

 

[duncdude]

That makes things perfectly clear!

... Not so sure I could write something similar to solve another problem though!!!

You're the daddy!

Thank you very much for your help Tony


Kind Regards
Duncan

 

[duncdude]

Tony

By the way - I notice you have some interest in Perl - IF I can ever be of any help with that please don't hesitate to ask - I would be more than happy to help


Kind Regards
Duncan