Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Minor |
Reported By: Roy Lambert Reported On: 7/20/2010 For: Version 2.03 Build 17 |
SELECT ALL "_ID" AS "_ID" FROM "Companies" INNER JOIN "Career" ON "_fkCompanies" = "Companies"."_ID" WHERE ("_fkOrgType" = 'A/ELEC' OR "_fkOrgType" = 'AERO' OR "_fkOrgType" = 'APPLEGATE' OR "_fkOrgType" = 'CAPEX' OR "_fkOrgType" = 'DEFENCE' OR "_fkOrgType" = 'ELECTRONIC' OR "_fkOrgType" = 'HQ' OR "_fkOrgType" = 'MAKER' OR "_fkOrgType" = 'MECHENG' OR "_fkOrgType" = 'NONCORE' OR "_fkOrgType" = 'PHARM' OR "_fkOrgType" = 'PROCESS') AND EXISTS (SELECT ALL "_fkCompanies" AS "_fkCompanies" FROM "Career" WHERE "_fkCompanies" = "Companies"."_ID" AND "_fkJobCodes" IN ('GM', 'CEO', 'MD')) <> TRUE
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |