![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
![]() |
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 Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |